Read Only Format Cannot Be Fixed?

[David Florida]

I use several Excel spreadsheets. I am running WIN 10. About a week ago, all of my Excel spreadsheets opened in READ ONLY format, including archived documents, new documents, and templates that I re-use frequently. I tried re-naming, save as, changing settings, etc., and other suggestions. Nothing would allow me to work in the spreadsheets again and just kept them in read only. I finally saved a new spreadsheet to an alternate drive on my computer and I was able to work around the issue, but no Excel spreadsheets in my "C" drive will function properly. This happened unexpectedly and I apparently did not have any updates or other matters that might have caused a change in settings or preferences. Anyone with any ideas??? Thanks.

 

[mole999]

are they saved as per user or in the root C directory as often security locks these down to admin only

 

[David Florida]

You just bumped a little above my pay grade, but if I understand the question, I am both the User AND the Administrator. I have gone into settings and/or preferences as Administrator and tried to both save as, and alter the settings (checking or unchecking boxes that I was told were the culprit), but it still opens everything from Excel, both old, new and newly created, in Read Only. Luckily I have a friend who is a bit of an Excel geek, but he's also stumped, and was the one who suggested my workaround of saving to my "D" drive where everything works fine--just a pain in the neck to have to go to the D drive every time to work on a spreadsheet.

 

[mole999]

Directory C:\ and C:\Windows plus others get locked down by the windows security settings nowadays. If you navigate to your folder where the files are stored so you can see the directory they are in, right click and set the read only to no, save that exit and restart windows and try again. check the files in the folder and see if they are locked

bright idea, you are not opening them via outlook are you, as that creates temp files that are read only