Hi,

I have a number of "child" spreadsheets that rely on a master spreadsheet
for their input. Calculations and charting are performed in the "child"
spreadsheets for different departments.

I need to refer to the master spreadsheet using a variable. For example, if
the master spreadsheet is located at \\server\share\folder1\folder2, I need
to be able to set this location to a variable, call it location, and then in
my "child" spreadsheets be able to enter something like

='location\[spreadsheet.xls]Sheet1'!$A$1

or perform more complex calculations.

Can this be done?

thanks

Dave