How to update reference files or not

[garethjohn]

Hello all

I have 2 spreadsheets.
1 master and 1 slave. The slave file contains all raw data and called RAW.xls
The master file has various formuls whichn looks for certain data within RAW.xls.

the key formula is below.

=IF(ISBLANK(VLOOKUP($J14,INDIRECT("[Raw.xls]"&$B14&"!$A$2:$R$99"),10,FALSE)),"",VLOOKUP($J14,INDIRECT("[Raw.xls]"&$B14&"!$A$2:$R$99"),10,FALSE))

The issue I now have, is that I need to send this file around to other collegues.
However whenever they open this, all the cells are #REF. I beleive this is because it needs the RAW.xls open as well to grab the data.

2 questions.

1: is there a way to run the formulas and have the data recorded saved.
2: is there a way to have a button to re-run the formulas based on updated data from RAW.xls. This would only be something someone does when they have the RAW file open as well.



I do not know much about VBA or marcos..just to be difficult!

thank you one and all!

[garethjohn]

Anyone know about this?