#1 By: howtogeek, May 30th, 2013 10:27
Originally published at: http://www.howtogeek.com/164011/how-to-convert-a-formula-to-a-static-value-in-excel-2013/
When you open an Excel worksheet or change any entries or formulas in the worksheet, Excel automatically recalculates all the formulas in that worksheet by default. This can take a while if your worksheet is large and contains many formulas.
#2 By: moree, May 30th, 2013 18:31
The Paste Special/Values option is also available in Excel 2010. 2007, 2003 and, I suspect, all earlier versions of Excel.
The second suggestion is technically accurate but really very unadvisable - to the extent possible you would want to keep formulae consistent across rows and columns so that you can drag across and down and get consistent results. Also, you would run the risk of changing the input data and not being aware that the expected calculation has not happened. In a business setting this could, at the worst, have a significant (negative) impact on decisions taken - not to mention being a CLM (career limiting move) for the author of the spreadsheet..
next page →