auto update formula and linking it to a cell

[rlan214]

Hi !
I would like to know is there anyways I can automatically update my formula by linking it...

The scenario
I have a worksheet that has calculation based on another file x
I'm doing alot of test cases and I would like to somewhat be able keep on changing the file x's and still get my worksheet to compute it...

here one of my formula example

=('\\F2-TACFPS-1\Sdata\Psa\Risk Evaluations\Weekly Risk MEMOS\Rick Test Folder\2007\Risk Profile Raw Data\Reports\[Report 01-15-2007 scheduled Lookback.xls]Modified Data'!B3-'\\F2-TACFPS-1\Sdata\Psa\Risk Evaluations\Weekly Risk MEMOS\Rick Test Folder\2007\Risk Profile Raw Data\Reports\[Report 01-15-2007 scheduled Lookback.xls]Modified Data'!C3)*(1/365)*(1/24)*((A4-A3)*24)

the bold ones are the ones that needs to be frequently changed

 

[HaHoBe]

Hi, rlan214,

if the file is open you could make good use of INDIRECT and the path located in a seperate cell. If not Replace could prove to be of good use or the use of the Links Dialog box. And you might even use VBA to alter the formulas - either when opening the workbook or by using a menu item, a shortcut or a button to start the macro...

Ciao,
Holger