Hi there,
I have been using your OpenOffice for many years now and I always save my files
as XLS format. I have link formulas between weeksheets and they worked OK in
the past. Today when I open my files and accept the update links prompt from
the file that contains the links, my links now show the #Ref errors. I tried
creating the link again but it doesn't work except if my link is to a cell that
contains text, if the cell contains formula, no longer works.
I down loaded your newest version 4.1, repeated all the steps and same thing
happens. I then tried saving the source file as the ods format and update the
links, keeping the target file as Xls format, that seems to fix the issue. I
then tried to change the source file back to Xls and update the links, same
issue occurred.
Is this a bug?
I have Window Vista. If you need more info, please let me know. Please look
into this.
Thank you for the free products and looking into this issue.
Diana