Have many cells using INDIRECT to read cell values from other spreadsheet files. When the file is saved and then reopened, I get Err
I get Err
which one (errors have numbers)? And why do you use INDIRECT()
and which LibreOffice version on which operating system? In addition it might be a good idea to show us at least one formula, which throws an error.
Assuming this is about Err:540 … when loading the document you should also get an infobar about external links with a button Allow updating … click that for trusted documents.
Or add a trusted location under Tools → Options → LibreOffice → Security, Macro Security, Trusted Sources, Trusted File Locations; and place the document in that folder. To always fetch external data without being asked from documents in those locations set Tools → Options → Calc → General, Update links when opening to Always (from trusted locations).
Thank you for your response. It is not a 540 error, of which I am quite familiar. All the files have been in trusted locations all along. However, I set up your suggestion “Update links when opening” to “Always (from trusted locations)”. Then I opened a file, entered a hyperlink to a text field in another file, and the text field was properly copied to the active sheet.
This could be the solution. However, I have had this problem off and on for several years. Sometimes it worked OK, other times not, and with no apparent reason for the difference.