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 7 Home Premium SP1, clean install, upgrade disc
 
 

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..

Rich
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

 
 

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
K10

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
.
.

Quote:
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.
Quote:
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.
Quote:
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
Reply

 All excel files opening in read only mode in Windows 7




Thread Tools



Similar help and support threads for2: All excel files opening in read only mode in Windows 7
Thread Forum
Excel files are not opening Microsoft Office
Error opening Excel file from windows explorer Microsoft Office
Solved IE9 Opening Excel file in same window as link Browsers & Mail
excel 2010 not opening from windows explorer Microsoft Office
excel opening as read only Microsoft Office
Problem opening Excel files Microsoft Office
Can't open 2003 Excel Files in Excel 2007? 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 04:58 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33