Fix/Freeze a spreadsheet
"Gord Dibben" wrote:
CopyPaste SpecialValuesOKEsc.
Then save.
Gord Dibben MS Excel MVP
Gord - Thank you for your excellent solution. Alan got in first, and as
such, inevitably gets the prime credit! I didn't see your post until
today... Thank you, again. What is perhaps very simple and/or obvious to
you is FAR from being such to the likes of me!
On Thu, 10 Apr 2008 15:45:01 -0700, alphamnemonic
wrote:
In Supercalc, I could save a spreadsheet as 'values'.
Formulae relating cells no longer operated.
The spreadsheet became 'dead'!
How do I do the same thing in Excel?
|