Fix/Freeze a spreadsheet
 

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?

Fix/Freeze a spreadsheet
 

Select the cells you want to remove the formulas from, (the whole sheet if
you wish). Right click 'Copy'. Right click again, 'Paste Special' check
'Values' OK.
Regards,
Alan.
"alphamnemonic" wrote in message
...
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?

Fix/Freeze a spreadsheet
 

CopyPaste SpecialValuesOKEsc.

Then save.


Gord Dibben MS Excel MVP


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?

Fix/Freeze a spreadsheet
 

"Alan" wrote:

Select the cells you want to remove the formulas from, (the whole sheet if
you wish). Right click 'Copy'. Right click again, 'Paste Special' check
'Values' OK.
Regards,
Alan.
"alphamnemonic" wrote in message
...
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?

I hope my 'thank-you' sent on the day of receipt of your solution got through to you. Your solution was exactly what I needed, and such was the number of problems solved by that solution that you instantly became 'God in my Universe'...!!!

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?