Trying to restore previous version of an excel file

[jumbo99]

I need to restore a previous version of a excel file to recover VBA code that's gone missing. I have tried to use the route, File, Info, Version history and can see many previous versions to restore. However, when I try to restore i get an error message: "There are unsaved changes in the current version of this file. Please save the current version before restoring a previous version".

I have tried but I still get the same error. Has anyone any ideas how to restore to an earlier version?

 

[NdNoviceHlp]

HI jumbo99. I suspect that if you open the task manager there will be an orphaned XL process running that you will need to end (Select the Excel process and then select End Process). Also, from an XL wb, if you go File, then Open, on the bottom right beneath available files there is a Recover Unsaved Workbooks button... maybe it will be useful after ending the process in the task manager. If that doesn't work, there is a registry route to remove resiliency items that may help. Check the task manager and Recover button things first. HTH. Dave

 

[jumbo99]

HI jumbo99. I suspect that if you open the task manager there will be an orphaned XL process running that you will need to end (Select the Excel process and then select End Process). Also, from an XL wb, if you go File, then Open, on the bottom right beneath available files there is a Recover Unsaved Workbooks button... maybe it will be useful after ending the process in the task manager. If that doesn't work, there is a registry route to remove resiliency items that may help. Check the task manager and Recover button things first. HTH. Dave

Many thanks, Dave. That has sorted it out and I have recovered a previous version so I can get access to my VBA code.

Regards,

 

[NdNoviceHlp]

You are welcome. Thanks for posting your outcome. Dave