View Single Post
  #3   Report Post  
Dmitry Kopnichev
 
Posts: n/a
Default

Hi!
Values in the "secure copy of the workbook as backup" change if I change
source data in the source workbook. I will need the values to be
recalculated in the original table later. The values will not recalculate if
I would make a "snapshot" of the worksheet.
"AlfD" wrote in message
ps.com...
Hi!

Have you tried making a "snapshot" of the worksheet? (Converting the
formulae into their values - fixed forever - using copy/paste special
values)

Just don't do it unless you have a secure copy of the workbook as
backup, becase the formulae can't be retrieved.

Alf