View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
alphamnemonic alphamnemonic is offline
external usenet poster
 
Posts: 3
Default 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?