G
GoodenowKZC
I am having a problem when linking two excel workbooks in Excel 2003:
My target workbook has 12 columns which are referencing 12 columns,
repectively in a different source workbook (a different excel file).
Periodically, and without any apparent reason, I will get #REF errors in the
linked cells, but ONLY WHEN IT IS REFERENCING ZERO VALUE CELLS IN THE SOURCE
WORKBOOK. All of the cells with non-zero values do not revert to #REF Errors.
I never had this problem with the previous version of Excel, and it appears
to be a glitch in Excel 2003. Can anyone provide some insight on this?
My target workbook has 12 columns which are referencing 12 columns,
repectively in a different source workbook (a different excel file).
Periodically, and without any apparent reason, I will get #REF errors in the
linked cells, but ONLY WHEN IT IS REFERENCING ZERO VALUE CELLS IN THE SOURCE
WORKBOOK. All of the cells with non-zero values do not revert to #REF Errors.
I never had this problem with the previous version of Excel, and it appears
to be a glitch in Excel 2003. Can anyone provide some insight on this?