AllI have an analysis spreadsheet that pulls data from sheets of several other spreadsheets.Under StarOffice, the technique I used was to open both spreadsheets, do a copy of the data in the source spreadsheet, go to a blank sheet in the receiving spreadsheet and do a paste-special with "link" specified.Under staroffice, when ever opened the receiving spreadsheet, it would automatically pull in the new data from the source spreadsheet even when the source spreadsheet was not open.Switch to LO and it will not link to the external data unless the source spreadsheet is open.I need to be able to link with out the source spreadsheet being open.Is there something I am doing wrong?A better way?I have many spreadsheets set up this way, so forcing a change will be painful.I have tried link to external data, but my experience(a bit stale, admittedly) was that if the region in the source spreadsheet grew since the original link was established, it did not pick up the newer data.greg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] linking in data from a file
Gregory Smith - Oracle Sparc Verification Fri, 22 Aug 2014 08:25:35 -0700
- [libreoffice-users] linking in d... Gregory Smith - Oracle Sparc Verification
- Re: [libreoffice-users] lin... Mark Bourne