C
Chris
I have a spreadsheet which is populated with a third-party add-in
called Baseline which introduces a number of custom formula options
for pulling market information into a local spreadsheet. That
spreadsheet can be opened by Excel 2003 users (without the Baseline
addin installed) as long as they do not update links; there are no
#name errors in the workbook. However, I can't open the same
spreadsheet in 2007 (again, no baseline addin installed) without
getting the #Name error anywhere a baseline function had populated the
spreadsheet. I am using Excel 2007 in compatibility mode.
There seems to be fairly straightforward options for disabling
automatic linking in 2007. With the workbook in question open, I
unchecked the "update links to other documents" under "when
calculating this workbook" in Excel options (advanced tab) and
immediately saved the document. When I exit Excel and relaunch the
same spreadsheet and check the option, it is checked again. When I
save the workbook I get a "minor loss of fidelity report" with the
following text: Some formulas in this workbook are linked to other
workbooks that are closed. When these formulas are recalculated in
earlier versions of Excel without opening the linked workbooks,
characters beyond the 255-character limit cannot be returned."
I don't see why the compatability checker is catching this error as
the workbook was created in Excel 2003 and was only opened for viewing
in Excel 2007. Does anybody have a good idea why this is happening?
Thanks
Chris
MS Vista Ultimate/Excel 2007
called Baseline which introduces a number of custom formula options
for pulling market information into a local spreadsheet. That
spreadsheet can be opened by Excel 2003 users (without the Baseline
addin installed) as long as they do not update links; there are no
#name errors in the workbook. However, I can't open the same
spreadsheet in 2007 (again, no baseline addin installed) without
getting the #Name error anywhere a baseline function had populated the
spreadsheet. I am using Excel 2007 in compatibility mode.
There seems to be fairly straightforward options for disabling
automatic linking in 2007. With the workbook in question open, I
unchecked the "update links to other documents" under "when
calculating this workbook" in Excel options (advanced tab) and
immediately saved the document. When I exit Excel and relaunch the
same spreadsheet and check the option, it is checked again. When I
save the workbook I get a "minor loss of fidelity report" with the
following text: Some formulas in this workbook are linked to other
workbooks that are closed. When these formulas are recalculated in
earlier versions of Excel without opening the linked workbooks,
characters beyond the 255-character limit cannot be returned."
I don't see why the compatability checker is catching this error as
the workbook was created in Excel 2003 and was only opened for viewing
in Excel 2007. Does anybody have a good idea why this is happening?
Thanks
Chris
MS Vista Ultimate/Excel 2007