Forum Discussion
Excel worksheets help
Did you perhaps inadvertently select all sheets before creating the table? If you see [Group] after the file name in the title bar, you have selected multiple sheets.
If your workbook is saved on OneDrive, you should be able to go back to a previous version: select File > Info > Version History.
If your workbook is saved locally, and if you are on Windows:
- Right-click the workbook in File Explorer.
- Select Properties from the context menu.
- Activate the Previous Versions tab and wait a few seconds for it to populate.
- If you see a recent version from before you messed things up, you can open or copy it.
- Otherwise, a recent backup is your only hope.
If you are on a Mac, I believe it has a similar feature - Time Machine or something like that.
Thx for your quick response Hans.
I am on windows 10 and not an excel expert ! I have tried what you have suggested and no previous versions available when I closed excel i saved changes ! I am so upset is there no hope at all ? I dont make back ups unless windows 10 carries out a backup
If you haven't made backups, I fear that your work is lost.
I strongly recommend making backups regularly from now on.
You may also want to turn on File History - see How to Turn On File History in Windows 10
- Ok Hans I'm Gutted thanks for your help
all the best
