Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: All excel files opening in read only mode in Windows 7

28 Feb 2011   #1

Windows 7
All excel files opening in read only mode in Windows 7

in windows 7, when i open any excel file from any folder (network & desktop both), it opens as read only..

but when i open the excel file by going to open option in the Menu Bar in MS Excel, it opens correctly.. but that takes hell lot of time everytime i wanna open a excel file..

can anyone suggest a way out..??

My System SpecsSystem Spec
28 Feb 2011   #2

Microsoft Community Contributor Award Recipient

Windows 10, Home Clean Install

Go to the folders involved, right click, properties, untick the read only.
My System SpecsSystem Spec
28 Feb 2011   #3

Windows 7

doesnt work..
My System SpecsSystem Spec

28 Feb 2011   #4

Windows 7 Pro x64 SP1

Question? Were these excel files created in another version of Excel that what your using?
Or were they attachments to emails?

questions, Questions..

My System SpecsSystem Spec
28 Feb 2011   #5

Windows 7

few of the files are of 2007 version whereas few of them are of 2003 version.
i have recd almost all files thru mails.. but i am having the same problem for the files created by me..!!

dont know wat xactly is the problem - but similar problem doesnt exist for word / powerpoint.. its only excel.. once i have opened any excel file & then i go to some folder and open excel file from there by double clicking it, then it opens in read-only mode.. but if i open the same file from the Open option in File Menu, then i dont have this problem..!! strange yet true..
but i cant keep on opening every excel file thru File->Open option.. it takes hell lot of time as the files are in different folders..!!
My System SpecsSystem Spec
28 Feb 2011   #6
Orbital Shark


The only thing I can think of is that the 1's downloaded need to be 'Unblocked'. Right-click and select Properties and there should be an 'Unblock' button, just click it.

Also, when you're saving files they may have accidentally been set to save as read only. Try the following...

1, Open an Excel Spreadsheet
2, Click File > Save As
3, Click the Tools dropdown then General Options...

Check to see that the 'Read-Only Recommended' hasn't been selected by accident...

All excel files opening in read only mode in Windows 7-excel.png

My System SpecsSystem Spec
01 Mar 2011   #7

Windows 7

nope.. no luck
My System SpecsSystem Spec
01 Mar 2011   #8

Windows 7 Home Premium 64bit

1. Which version of Outlook (Office) are you using?

2. Do you save the attachments to your hard drive before trying to edit?
My System SpecsSystem Spec
03 Mar 2011   #9

Windows 7 64 bit

I also had the same problem, try disable file preview from Explorer, see attachment...

It seems for some reason the file is "locked" or something similar when preview is enabled, in any case disabling this feature solved the problem for me, no more Excel file opened in read-only mode.

Attached Thumbnails
All excel files opening in read only mode in Windows 7-clipboard01.jpg  
My System SpecsSystem Spec
03 Mar 2011   #10

Windows 7 Home Premium 64bit

Lots of information here:
Outlook 2010 & Read-Only Attachments

Solution - Edit Message Method

If you put the email message into Edit mode you can edit the attachment and save changes back to the original attachment on the email message. You need to remember to save the attachment when closing AND save changes to the email message as the copy in the securetemp folder will be deleted when you close Outlook.
If you add the Edit Message button to the QAT or Ribbon, its very easy to get into Edit mode. To add the command to the QAT (or ribbon):
  1. Open a message
  2. Go to File, Options, then choose either Customize Ribbon or Quick Access Toolbar
  3. Select All Commands from the Choose command dropdown
  4. Click in the list of commands then press E on your keyboard to jump down to the Edit commands.
  5. Find Edit Message and double click on it or use the Add button to add it to the QAT or Ribbon.
  6. Click OK to return to the message.
The next time you need to edit an attachment and save the changes back to the message, open the email message, click the Edit Message button then open the attachment.
Remember: you need to save and close the attachment then save and close the email message for the edits to be saved. If you don't want changes saved (such as when rotating images), close without saving.
Solution - Disable Attachment Preview

You can make many attachments readable if you disable Attachment Preview. With this disabled you will lose the ability to view attachments in the Reading pane or open messages - you will need to double click to open them in their application.
Go to File tab, Options, Trust Center:
  1. Click the Trust Center Settings button
  2. Select Attachment Handling
  3. Add a check to the "Turn off attachment preview" option.
Note: this disables preview for all attachments. If you like the attachment preview feature, use the Edit message method.
Solution - Images viewed with Windows Photo Viewer

A workaround for those using Photo Viewer exists: in Photo viewer, click on File, Properties, General tab then clear the Read only check. Repeat for each image.
My System SpecsSystem Spec

 All excel files opening in read only mode in Windows 7

Thread Tools

Similar help and support threads
Thread Forum
Excel Opening in read only (1 user, 1 network share folder)
I have one PC that the user opens a shortcut on the desktop to a network share and as of yesterday morning all of the excel files are opening in read only mode. All other excel files both local and network open fine. If I log onto that PC I can open those same files in edit mode. I have checked...
Microsoft Office
Excel files are not opening
I love the new taskbar and the "right click" on a pinned programme to access recent files & pinned files. However, while this feature works perfectly for Word, when I try to open an excel file from the taskbar, or even as an attachment to a received e-mail, I get the message " there was a problem...
Microsoft Office
MSO10 Starter won't read Excel 2003 files
Computer 1: Windows 7 sp1 & Office 2010 Starter After Patch Tuesday 9/10/2013, Excel 2010 is no longer able to read Excel 2003 files. In fact, all Excel 2003 files have changed from the standard Excel Icon to a non-standard orange Icon. Attempts to open these files will bring up the Install...
Microsoft Office
excel opening as read only
i have a weird issue...i open an excel worksheet (both from the server and from desktop) and every now and then they open as read only and i've worked on them in the past. when this happens i have to reboot my laptop and the problem is gone. This happens very randomly...has anybody had this issue...
Microsoft Office
Problem opening Excel files
I moved from Vista to W7 using EasyFileTransfer (which worked far better than I expected!!), changed computers, and this problem, which I saw for months on Vista on the previous PC has followed to the new one: If I double-click on any Excel (and only Excel, other Office apps A-OK) file, Excel...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 17:49.
Twitter Facebook Google+