This is starting to get a little frustrating.
I'm using Excel 2007 and have what I believe to be very similar workbooks with the same external link settings in Options and Trust Center.
However, one workbook (#1) opens without returning #REF! for the external links which is what I want.
The other workbook (#2) opens and immediately returns #REF! for most of the external links which forces the user to open linked file to clear the reference errors. The users don't like this and tend to blame me for causing them problems.
Does anyone have thoughts on why this might be occuring? Thank you!
P.S. This is my second and last question for today kind people
I'm using Excel 2007 and have what I believe to be very similar workbooks with the same external link settings in Options and Trust Center.
However, one workbook (#1) opens without returning #REF! for the external links which is what I want.
The other workbook (#2) opens and immediately returns #REF! for most of the external links which forces the user to open linked file to clear the reference errors. The users don't like this and tend to blame me for causing them problems.
Does anyone have thoughts on why this might be occuring? Thank you!
P.S. This is my second and last question for today kind people