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
|