You may find at sometime that you are not able to right click of a worksheet tab, somehow the click does not respond. The problem stems from a corruption in the start-up files, why this happens is not clear.
If this is happening to you, you are amongst many of us, and fortunately there is a fix. Just follow my advice below:
- Open windows explorer and navigate to C:\Users\User_Name\AppData\Roaming\Microsoft\Excel If you are struggling then copy the detail in the punctuation and paste this into your explorer "%appdata%\Microsoft\Excel")
- You should see a number of folder and possibly a file and see if is contains Move those files to some other location as a backup.
- You should now have an explorer folder with no folders or files.
- Open up Excel and try the right click on a worksheet tab.