I have excel files that I’d like to use with LibreOffice only.
Each file has several sheets and in almost all sheets there’s a link to the same sheet in a previous file. When using excel to open a file, I’m asked “Security warning - Automatic update of links has been disabled” and clicking on “Enable Content” button I get them updated.
When using LibreOffice Calc to open the same file, I get an almost identical warning and button, yet, after clicking it, if I compare the linked values, they’re not updated. (Normally only the current sheet is updated, not sure it happens all the times). Afterwards, if I edit the cell content, similar to:
=‘file:///C:/Users/gianc/filename.xlsx’#$sheet_name.$D$6
and re-type some characters leaving the same contents, then the link is updated.
Any hint?
Thanks a lot!
Giancarlo.