All excel files opening in read only mode in Windows 7

Page 1 of 2 12 LastLast

  1. Posts : 4
    Windows 7
       #1

    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 Computer


  2. Posts : 17,796
    Windows 10, Home Clean Install
       #2

    Go to the folders involved, right click, properties, untick the read only.
      My Computer


  3. Posts : 4
    Windows 7
    Thread Starter
       #3

    doesnt work..
      My Computer


  4. Posts : 1,800
    Windows 7 Pro x64 SP1
       #4

    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 Computer


  5. Posts : 4
    Windows 7
    Thread Starter
       #5

    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 Computer


  6. Posts : 6,305
    Windows 7 Ultimate x64
       #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 Computer


  7. Posts : 4
    Windows 7
    Thread Starter
       #7

    nope.. no luck
      My Computer


  8. Posts : 3,009
    Windows 7 Home Premium 64bit
       #8

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

    2. Do you save the attachments to your hard drive before trying to edit?
      My Computer


  9. K10
    Posts : 1
    Windows 7 64 bit
       #9

    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 Attached Thumbnails All excel files opening in read only mode in Windows 7-clipboard01.jpg  
    Last edited by K10; 03 Mar 2011 at 11:13.
      My Computer


  10. Posts : 3,009
    Windows 7 Home Premium 64bit
       #10

    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 Computer


 
Page 1 of 2 12 LastLast

  Related Discussions
Our Sites
Site Links
About 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 01:12.
Find Us