Inactive Cells

Question

Hello,

I'm trying to perform some very basic functions (count, sumif, etc...) but the formulas aren't working.  I've checked that the calculations are set to automatic and the worksheet isn't protected or locked.  The cells are all formatted to General, but the problem seems to lie in the formatting.  If I go into a cell and press F2 then enter, the cell is recognized by my formulas.  Since the spreadheets have tens of thousands of rows and dozens of columns, doing this for each cell is out of the question.  Could someone point me to a more appropriate solution that would "activate" all the cells at once?  I would really appreciate it. 

Thanks

Hans

Answer 1

Select the cells.

Press Alt+F11 to activate the Visual Basic Editor.

Press Ctrl+G to activate the Immediate window.

Type the following line, then press Enter:

Selection.Value = Selection.Value

Press Alt+F4 to close the Visual Basic Editor.

Answer 2

Thanks a lot, in the mean time I found a solution that worked but I followed your recommendations also.  Anyhow, thanks for the help!

Cheers