L
Larry Mehl
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
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