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!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!