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