References to open/hidden workbooks become hard-coded in formulas- 2003
 

Hello --

Can someone tell me if the following problem is caused by an Excel
configuration setting, or is there another reason for it?

Problem: References to cells in opened, protected, and hidden workbooks
become hard-coded in formulas.

In the set of related workbooks we deliver to a user, an example formula
merely includes the workbook name, as in
= Engineering.xls!cx_qam

When he sends the set of workbooks back to us for checking, debugging,
etc., this formula appears as
= 'C:\Documents and Settings\username\My
Documents\folder_path_below_this\Engineering.xls'! cx_qam

Thanks for any help or direction on this.

Larry Mehl

References to open/hidden workbooks become hard-coded in formulas - 2003
 

see your post under general questions.
-----Original Message-----
Hello --

Can someone tell me if the following problem is caused
by an Excel
configuration setting, or is there another reason for it?

Problem: References to cells in opened, protected, and
hidden workbooks
become hard-coded in formulas.

In the set of related workbooks we deliver to a user, an
example formula
merely includes the workbook name, as in
= Engineering.xls!cx_qam

When he sends the set of workbooks back to us for
checking, debugging,
etc., this formula appears as
= 'C:\Documents and Settings\username\My
Documents\folder_path_below_this\Engineering.xls' !cx_qam

Thanks for any help or direction on this.

Larry Mehl
.