H
Heers Muhgoo
I have a situation where I'm using Excel 2000 with a
workbook containing references to another workbook. When
opening the first workbook & the second workbook is not
available, you can say "no" to the update external links,
and still see all values as they were when the first
workbook was last closed.
However, when the same workbook is opened in Excel 2002 or
2003, the external links specified only as a cell reference
show the proper data (e.g, =wbkname!E1), but when they are
Excel formulae (specifically a SUMIF), I'm getting a #VALUE!
error in the pertinent cells
Is there a way to get the values to show without having to
provide my target audience the second workbook, as we are
able to do in Excel 2000.
TIA
Mike
workbook containing references to another workbook. When
opening the first workbook & the second workbook is not
available, you can say "no" to the update external links,
and still see all values as they were when the first
workbook was last closed.
However, when the same workbook is opened in Excel 2002 or
2003, the external links specified only as a cell reference
show the proper data (e.g, =wbkname!E1), but when they are
Excel formulae (specifically a SUMIF), I'm getting a #VALUE!
error in the pertinent cells
Is there a way to get the values to show without having to
provide my target audience the second workbook, as we are
able to do in Excel 2000.
TIA
Mike