I use thousands of references to spreadsheets that don't exist yet (but will eventually)in conjunction with the IfError function: =IfError("path and name of future file",0,"path and name of future file, tab name and cell reference"). I'm copying a workbook with lots of formulas like this and prepping for the our next fiscal year. Excel no longer allows me to use Replace All for this; is there a setting I need to change so that it won't stop replacing when it hits the first invalid link?
Sure, with the old version, I had to hit the enter key repeatedly when using this function...but at least it did it. Help!