Thread
:
Using "track changes" to revert to a previous save
View Single Post
#
3
Alan
Posts: n/a
"Sean Carter" <Sean
wrote in message
...
Hi,
I use a shared spreadsheet that tracks changes for 30 days. End of
the month I perform a save as and store the old file from the
previous month for our records. This month I accidentally just hit
save and didn't realize I didn't have a copy from April till a few
days later. Is there a way to revert my spreadsheet to reflect what
it was on the 30th of April and then do a save as at that point?
Thanks,
Sean
Hi Sean,
I looked into that a while back and couldn't find an answer - doesn't
mean it cannot be done, just that I failed to find a way.
For future reference, perhaps you could write some code that keeps a
track of each change 'manually' (via VBA, not using the track changes
funtionality). You could then build a 'roll back' function around
that record of changes.
I thought about it, but couldn't justify the time for me to work it
out. It may be easy coding, but I am not expert enough.
HTH,
Alan.
Reply With Quote