Hi,
Michael Crawford schrieb:
Greetings,
I have a problem with export to Excel. Many of my formulas are
changed to NA() when I open the Excel format version back into
OpenOffice again. Can someone help me export my spreadsheet? I might
actually have a bug in my spreadsheet that's my own fault, but I can't
find it. Maybe you can help me out. I promise to make it worth your
while.
[...]
I have tested your spreadsheet in OOo 1.9.103, export to Excel works
very well. No more #N/A errors anymore, as far as I can see. :-)
The message "Do you want to update..." occurs because your document
contains a hidden linked sheet to another spreadsheet document. Such a
sheet is created by Calc automatically, if you enter a link to that
document in a formula, e.g. by clicking into the other document while in
formula edit mode. This is how external links work in Calc: a hidden
sheet is created, the values are loaded from the external document, and
the formulas use the values from the hidden sheet instead from the
external document. This makes calculation of the formulas faster, and
the formulas still work if the external document is not available anymore.
You can remove the sheet as follows:
Format -> Sheet -> Show... -> OK
Edit -> Sheet -> Delete... -> Yes (or right-click on the sheet tab)
Save
Regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
