Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel 2010 file read only

Posted on 2014-12-09
5
Medium Priority
?
148 Views
Last Modified: 2014-12-10
Surprisingly I could not find this with a search.  Some, not all, Excel files created by myself will not let me save them because they are read only.  I have unchecked everything in the Trust Center.  I found references to the "Microsoft Office Button", which leads to Backstage, but cannot find it!  And the description implies it is nothing more then the Options Trust Center GUI anyway.  I either get "read only" or "Cannot save to this location, do you want to save in your Documents?"

uSoft just really makes it hard to manage files when I created them, and am the only user of this machine in my home office.

Office 2010
Windows 8.1Pro
Toshiba notebook
0
Comment
Question by:Mike Caldwell
  • 3
  • 2
5 Comments
 
LVL 99

Expert Comment

by:John Hurst
ID: 40490492
Normally anything you can create you can open and work on.

If you had saved the problem files to a CD / DVD, that makes them read only. I think when you bring them back, they remain read only.

Using Windows Explorer, find a problem file, right click on it, select Properties, uncheck the read only box. Now see if you can open the file, work on it and save it normally.
0
 
LVL 1

Author Comment

by:Mike Caldwell
ID: 40490569
I did create it, and it was never saved to anything except a local HDD.  However this is a new machine, so I copied several hundred K files from the old machine to this one.  But the read only box was not checked, and I went through each drive (I have five logical drives) and made sure everyone on planet earth had permission.  It is consistent on a given file, but the ones with the problem are a small %.  Still, I need them to save after modification.
0
 
LVL 99

Accepted Solution

by:
John Hurst earned 2000 total points
ID: 40491043
Take one of the problem files, open it, and then save it as a new name. Does the new name work?
0
 
LVL 1

Author Comment

by:Mike Caldwell
ID: 40491673
Yes.  I had done that before.  I was hoping to figure out what causes this but no use driving it to the ground when there is a work around.  I was trying to avoid saving under a new name, deleting the old file, then renaming the new one.  Thanks for your time.
0
 
LVL 99

Expert Comment

by:John Hurst
ID: 40491688
Thanks Mike, and I was happy to help.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question