Greetings,
I have a spreadsheet with the following formulas in columns (with a lot more all in number order):
='C:\...\[244GADS .059.08.001.xls]Test'!$F$1
='C:\...\[244GADS .059.08.002.xls]Test'!$F$1
I have a spreadsheet with the following formulas in columns (with a lot more all in number order):
='C:\...\[244GADS .059.08.001.xls]Test'!$F$1
='C:\...\[244GADS .059.08.002.xls]Test'!$F$1
='C:\...\[244GADS .059.08.003.xls]Test'!$F$1
They work fine except some of the reference files do not exist yet and so I get a ref error which is fine. When a file is added to the same folder I have to go back to the spreadsheet and approve each formula for it to recognize the new file. Is there a way so that as I add new files (ie. 244GADS .059.08.004) I will not have to manually approve the formula.
Thanks for any assistance
They work fine except some of the reference files do not exist yet and so I get a ref error which is fine. When a file is added to the same folder I have to go back to the spreadsheet and approve each formula for it to recognize the new file. Is there a way so that as I add new files (ie. 244GADS .059.08.004) I will not have to manually approve the formula.
Thanks for any assistance