Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loss of fidelity question
I have a workbook that was originally created in Excel 2003. It has multiple
links to other workbooks. When I go to save the data, I receive a message that states there is a minor loss of fidelity. "Some formulas are linked to other workbooks that are closed.....Characters beyond the 255 character limit cannot be returned." When I click on Find in the Compatibility Checker, it shows 5 cells as the problem. The cells contain If statements. I don't understand what the problem is though. The formulas only contain 126 characters. Can anyone help me? Thanks so much!! =IF('H:\Evaluations\Test 2008-2009\[questions.xls]Sheet1'!A2<0, 'H:\Evaluations\Test 2008-2009\[questions.xls]Sheet1'!A2, "") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loss of fidelity question
Try to open questions.xls before trying to save your file.
The warning is because Excel does not know, at the time of saving, what your formula will return... evern otherwise in case of IF statement it might not know the result and issue a warning... If it is not an issue, then save it in 2007 format. -- If you find this post helpful pl. choose "Yes"... "Sue" wrote: I have a workbook that was originally created in Excel 2003. It has multiple links to other workbooks. When I go to save the data, I receive a message that states there is a minor loss of fidelity. "Some formulas are linked to other workbooks that are closed.....Characters beyond the 255 character limit cannot be returned." When I click on Find in the Compatibility Checker, it shows 5 cells as the problem. The cells contain If statements. I don't understand what the problem is though. The formulas only contain 126 characters. Can anyone help me? Thanks so much!! =IF('H:\Evaluations\Test 2008-2009\[questions.xls]Sheet1'!A2<0, 'H:\Evaluations\Test 2008-2009\[questions.xls]Sheet1'!A2, "") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minor loss fidelity | Excel Discussion (Misc queries) | |||
Exccel 2007 puzzling "loss of fidelity" | Excel Discussion (Misc queries) | |||
loss of fidelity error when saving excel work book | Excel Discussion (Misc queries) | |||
loss of fidelity error when saving excel work book | Excel Worksheet Functions | |||
loss of fidelity message | Excel Worksheet Functions |