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: [email protected]
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
