keme wrote:The DDE path should work. You need a DDE server application. Not sure whether Calc is sufficient when you are working with Excel data, or whether you must have Excel for this to work.
Another possibility is to register the spreadsheet as a database and extract data from that.
Mixing Excel and Calc data formats carries a risk of random error/incompatibility. Is it practical to save that file as an ODS?
(Excel in later incarnations - after 2007 - can save as ODS. If the data source is a third party application - whether Excel macros or standalone app - saving may be hardcoded to use an Excel-specific file type and you are out of luck.)
Not a great peril, perhaps, so "if it works, don't fix it". Just thought it was worth mentioning.
catbill wrote:Villeroy, Thank you for the helpful reply.
I could get as far as Data > Define Range, where I did not see a new database range Import1.
Any thoughts about what went wrong and how I can make this work?
Also, a few more questions:
Is there a name for this type of link, other than linked database range?
When do the Excel and LibreOffice files need to be open for the updating to work?
More generally, are there other ways to create a chart using external data? If so, what are they?
I am trying to understand all of the options including advantages and disadvantages.
there must be a way to attach them.
Users browsing this forum: Google [Bot] and 19 guests