Replace changes in Excel
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!
Software/Hardware used:
Excel 2010
Sure, with the old version, I had to hit the enter key repeatedly when using this function...but at least it did it. Help!
Software/Hardware used:
Excel 2010
ASKED:
February 7, 2012 7:54 PM
UPDATED:
February 28, 2012 3:05 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
Michael Tidmarsh 
11,380 pts. ,
Michael Tidmarsh 0 pts.
11,380 pts. ,
Michael Tidmarsh 0 pts. To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
