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.

moree
—
2013-05-30T22:31:19Z —
#2

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..

jeanv
—
2014-05-29T21:23:56Z —
#4

I've been using this method so much I created a macro for it, but I'm now running into a snag, and I hope someone can help me out.

Some of the cells that I convert refer to empty cells, so the conversion leaves me with a cell that LOOKS empty. Unfortunately, if using Ctl-Up or Ctl-Down to find the end of the data range, it turns out that those "empty" cells aren't so empty after all. I can only empty them by Deleting.

Since I'm trying to automate stuff with VBA, I'm looking for a way to make them truly empty, or at least recognized as blank. Any help out there please? Pretty please???