paste values

[Bailey]

I have a data table in my spreadsheet that I have used paste special in order
to stop the cells from recalculating when I hit F9. Now I would like to undo
the paste special in order to recalculate, but not sure how to do this. Any
suggestions?
Thank you

 

[Jon Peltier]

Once you've overwritten formulas with values, your formulas are gone. You
would need to recreate them.

- Jon

 

[Mark Ivey]

Just a thought...

What about pasting the unchanged "values" to a temporary worksheet. Then
they could be referenced at a later time.

Mark Ivey

 

[Gord Dibben]

If you have saved the workbook there is no going back.

If you haven't saved, try the "Undo" button.

You may get lucky.


Gord Dibben MS Excel MVP