Freeze a cells calculation

[frankday]

I am working on a ranking workbook. At the beginning of the season I rank a hole bunch of in information on a sheet. Once there ranked I want to lock in those number until the next year when I want to rank them again. How can I make this happen.

Thanks in advanced.

 

[starl]

If you're using formulas, replace the formulas with the values (Copy the range, Paste Special Values to replace the formulas).
Anything else risks the cell recalculating accidentally