I want to archive a spreadsheet (and freeze those cells that want to
update itself) so that when I access it one year later, it no longer
updates the cells that have functions like " =today() ". I would
want to freeze those particular cells so that when I froze those
cells, they show the last date when frozen. I guess it would be as if
the spreadsheet became a text file.

Is there a command/function within excel to do this?

Hi, Doug.

One way to do this is the following:

CTRL + a (selects all cells)
CTRL + c (copy)
Edit Paste Special, then select Values and OK.

This will remove all formulas.

HTH

Jason

"doug" wrote:

I want to archive a spreadsheet (and freeze those cells that want to
update itself) so that when I access it one year later, it no longer
updates the cells that have functions like " =today() ". I would
want to freeze those particular cells so that when I froze those
cells, they show the last date when frozen. I guess it would be as if
the spreadsheet became a text file.

Is there a command/function within excel to do this?

Jason, thanks a lot. It works like a charm and exactly what I wanted.

--doug--








On Thu, 22 Feb 2007 19:41:10 -0800, Jason
wrote:

Hi, Doug.

One way to do this is the following:

CTRL + a (selects all cells)
CTRL + c (copy)
Edit Paste Special, then select Values and OK.

This will remove all formulas.

HTH

Jason

"doug" wrote:

I want to archive a spreadsheet (and freeze those cells that want to
update itself) so that when I access it one year later, it no longer
updates the cells that have functions like " =today() ". I would
want to freeze those particular cells so that when I froze those
cells, they show the last date when frozen. I guess it would be as if
the spreadsheet became a text file.

Is there a command/function within excel to do this?