Excel for mac vba extract data from closed workbook

broken image
broken image

Now that you are here, you can find solutions to this dilemma.

broken image

It's tough to decide as each choice will force you to give up something. One is closing the Excel file without saving to restore the deleted worksheet, and the other is clicking the save button to keep all the changes but lose the chance to undo deleted files. Working on an Excel document but accidentally deleted a worksheet tab with essential data? It's a disaster! At this moment, you usually have two choices to go on.

broken image

Open Excel > click 'File' and 'Info' > click 'Manage Workbook' > choose Recover. Full stepsĭownload Excel file recovery software > choose a location to scan > preview and recover. Open the excel file > click 'Home' > click 'History' > click 'Previous'. Go to 'File' > click 'Save as' > re-open the original Excel document > copy.