Am 29.01.2012 01:44, Steve Smith wrote:
Thanks for the reply Andreas.
Please view the following link: http://youtu.be/UWTVKzp6kV8
I believe that will explain my question.
I have learned something during my experimentations. If the files are in ods
format, the update works correctly. It is
And by the way: Your video explains nothing since it does not tell
anything about the type of link which refuses to update nor does it
indicate that it is an Excel file.
Just in case you are using a formula link like this:
='file://path/file.xls'#Sheet1.$A$1 (again, there are 4 other methods in
Am 27.01.2012 22:29, Steve Smith wrote:
Understand linking, I think. My question is updating the link.
If the source spreadsheet is not opened when a link to external file is updated (Edit
- Links... - Update), I receive a #REF! error.
Again, I'm aware of 5 different ways to link
Thanks for the reply Andreas.
Please view the following link: http://youtu.be/UWTVKzp6kV8
I believe that will explain my question.
I have learned something during my experimentations. If the files are in ods
format, the update works correctly. It is when the files are in xls format
that
Am 27.01.2012 21:02, Steve Smith wrote:
I have a series of spreadsheets with external links to other spreadsheets. The
link will not update unless the spreadsheet the link references is open.
Is that the expected/desired response of the developers?
There are 5 different ways to link
:56 PM
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: LibreOffice Calc: Update External Link
Question
Am 27.01.2012 21:02, Steve Smith wrote:
I have a series of spreadsheets with external links to other spreadsheets.
The link will not update unless the spreadsheet the link
(Edit - Links... - Update), I receive a #REF! error.
Thanks!
-Original Message-
From: Andreas Säger ville...@t-online.de
Sent: Jan 27, 2012 2:56 PM
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: LibreOffice Calc: Update External Link
Question
Am 27.01.2012 21:02