[libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-29 Thread Andreas Säger
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

[libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-29 Thread Andreas Säger
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

[libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-28 Thread Andreas Säger
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

Re: [libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-28 Thread Steve Smith
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

[libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-27 Thread Andreas Säger
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

Re: [libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-27 Thread Steve Smith
: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

Re: [libreoffice-users] Re: LibreOffice Calc: Update External Link Question

2012-01-27 Thread Thomas Damratowski
(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