Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box / Hard Coded List | Excel Discussion (Misc queries) | |||
Hard coded formula fix, VBA for column ordering | Excel Worksheet Functions | |||
do the same thing to multiple hard coded cells | Excel Worksheet Functions | |||
References to open/hidden workbooks become hard-coded in formulas - 2003 | Excel Discussion (Misc queries) | |||
Find Hard Coded Cells | Excel Programming |