Excel shows "#VALUE!" Until i select the cell, select the formula bar, then select a new cell. After that it will show the correct value. Is there a way to fix this in mass? I have >2000 cells I would like to fix, and doing it by hand is not worth the time.
Edit: I just fixed it by manually clicking the first set of calculations then copy and pasting it over the rest. But I would still appreciate any suggestions should this happen in the future.
