Hi all
Just downloaded the latest verson of libreoffice and opened an excel wb
Can anyone tell me why I get the message attached excel.png
I never had this message when using ms office? would just like to know what it is?
Any advice much appreciated
legepe
Likely the Excel file you opened has external references to a file similar to the one displayed in the dialog and Calc tries to access it to refresh data, but that file isn’t present (anymore) or some relative path resolution fails. The repeated Users/.../AppData/Roaming/Microsoft/Excel/
with two different user names legepe
and leigh
looks odd, as if it should had been file:///E:/Users/leigh/AppData/Roaming/Microsoft/Excel/Book-2.xlsx
instead.
… and could that be a problem with relative reference that was pointing to “./Users/leigh/AppData/Roaming/Microsoft/Excel/Book-2.xlsx”, and current path was prepended like that? I guess that, without the problematic file itself, it’s impossible to know if that’s a bug or a normal thing…
Yes, it looks like a relative reference problem. My guess is the original document was created as user leigh
with an external reference to a Book-2.xlsx
file, and after that the referencing document was moved or copied to user legepe
and opened from there so things don’t match anymore. If so, copying Book-2.xlsx
to the user legepe
's Excel directory might help. And yes, without seeing the document everything is speculation.
Thanks for your replys… your all right I guess… the original doc has probably been moved several times and the most recent been full os reinstall… things have just got messed up along the way…