Re: [libreoffice-users] linking in data from a file

Gregory Smith - Oracle Sparc Verification wrote:
> All
> I 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?

Check the setting Tools > Options > LibreOffice Calc > General > Update 
links when opening.

It should be possible to update the data on demand through Edit > 
Links... > Update.

> 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.

You copied a range of cells and pasted them as linked, so only those 
cells are linked. Data added to the source sheet outside of that range 
won't be copied across.

You probably need to use Insert > Sheet From File and select the "Link" 
option, to get the whole sheet and its contents. Don't add other info, 
formulas etc. to the imported sheet - it's content is completely 
replaced when updated so you'd lose your additions. Instead, the data 
can be referenced by formulas on other (non-linked) sheets.

Mark.

--
To unsubscribe e-mail to: users+unsubscribe@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