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
Solved

Excel 2010 file read only

Posted on 2014-12-09
5
140 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 93

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 93

Accepted Solution

by:
John Hurst earned 500 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 93

Expert Comment

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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
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…

809 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