Forum Discussion
Turn Off Read Only
Hey guys, Hoping someone can help out with this, there are 5 of us here in the office all using our boss' Microsoft office licence. Mainly using excel and unable to open Excel files at the same t...
I have the solution, I opened Excel in safe mode and searched for the issue and I found out that the problem is due to an Add-in, the Excel seemed not to find the add-in location and the security check prevent any modifications to the file as it might be a virus.
Anyway, the solution that I'm sure it will work 100% with you is:
1- Open any excel file
2- Open developer menu
3- Click on Add-ins
4- Uncheck all the add-ins
5- If any of the add-ins is failing and causing the issue it will give you an error message and it will remove it
6- Close and re-open excel
7- The file now should be opened normally
Open the add-ins you use again (preferably one by one) and check after opening each one, if the problem persists, then the last one you opened is also making a problem.
Anyway, the solution that I'm sure it will work 100% with you is:
1- Open any excel file
2- Open developer menu
3- Click on Add-ins
4- Uncheck all the add-ins
5- If any of the add-ins is failing and causing the issue it will give you an error message and it will remove it
6- Close and re-open excel
7- The file now should be opened normally
Open the add-ins you use again (preferably one by one) and check after opening each one, if the problem persists, then the last one you opened is also making a problem.
- Hi, where is the Developer Menu? I can't find it anywhere, thanks, Susan
The Developer tab of the ribbon is available in the desktop version of Excel for Windows and MacOS.
Windows:
- Select File > Options.
- Select Customize Ribbon.
- Tick the check box Developer in the list of Main Tabs on the right.
- Click OK.
MacOS:
- Select Preferences... from the Excel menu at the top.
- Select View.
- Under In Ribbon, Show, tick the check box Developer.
- Close the dialog.
I have the same problem and don't have any add-ins on the file
bnm411 I am suddenly having the same problem. MS converted all files to read-only. I know how to save as with new filename. It won't let me. Every time I tell it to, it says that file already exists! Which it does not! This is clearly an MS problem...I supposed related to its new reliance on AI. Argghhhh.
cilla1955 HI, if you receive a response with a solution will you please share it with me, I'm very frustrated with it, Thanks, Susan
