Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel 2010 file read only

Posted on 2014-12-09
5
Medium Priority
?
144 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 98

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 98

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 98

Expert Comment

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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

688 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