Excel Find and Replace Issues
Posted on 2011-03-21
I have to replace formulas in Excel from 2010_2012 to 2011_2012. Sounds simple enough right?
For whatever reasons Excel wants me to save/update each individual cell while it tries to replace them. Since I have over 100,000 replacements to make across a bunch of sheets that won't fly.
Is there a way to use find and replace so it only worries about replacing the formulas and not saving each cell. Yes I have selected all cells to be replaced at once, still the same problem.