ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exccel 2007 puzzling "loss of fidelity" (https://www.excelbanter.com/excel-discussion-misc-queries/166552-exccel-2007-puzzling-loss-fidelity.html)

andy62

Exccel 2007 puzzling "loss of fidelity"
 
I have a file developed in Excel 2003 that I brought up in Excel 2007, to
confirm functionality. Everything worked fine, but when I went to save the
file the compatibility checker reported "minor loss of fidelity" due to the
following:

"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.
Location: Defined Names
Number of Occurences: 15"

I did at one point copy some functionality from another workbook into this
one, but have checked formulas, defined names, and VBA code for outside
references, and see none. I moved the file to another computer with Excel
2003, then ran and saved the file with no mention of outside links. I don't
know what else to do to resolve the problem (assuming there is one). Anyone
have any ideas? TIA

andy62

Ignore
 
Ignore this request. Upon rechecking, some extraneous, externally
referencing names were created, probably when I copied in the functionality.

"andy62" wrote:

I have a file developed in Excel 2003 that I brought up in Excel 2007, to
confirm functionality. Everything worked fine, but when I went to save the
file the compatibility checker reported "minor loss of fidelity" due to the
following:

"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.
Location: Defined Names
Number of Occurences: 15"

I did at one point copy some functionality from another workbook into this
one, but have checked formulas, defined names, and VBA code for outside
references, and see none. I moved the file to another computer with Excel
2003, then ran and saved the file with no mention of outside links. I don't
know what else to do to resolve the problem (assuming there is one). Anyone
have any ideas? TIA



All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com