none
Excel file opens in read-only mode

    Question

  • Hi,
    In moss 2007 application when tey to open excel sheet it opens in read only mode.
    Just wanted to know is it lthat documnets opens in read-only mode in moss 2007?
    if not then how can we rectify this issue?

    We are not trying  to open excel sheet in edit mode.

    Br,
    Anitha Vyas

    • Moved by Mike Walsh FIN Wednesday, February 24, 2010 11:29 AM Baffled by the concept that this is a Search question. Moving to Admin (From:SharePoint - Search (pre-SharePoint 2010))
    Wednesday, February 24, 2010 11:13 AM

Answers

  • Anitha,

    Try this KB and let me know if this fixes it for you. There is also a registry entry that can be tweaked to open files in read write mode but I would not recommend that since one it involves configuration on each individual machine and secondly ur machines might get hosed coz of registry entries being incosistent.

    http://support.microsoft.com/kb/287402
    Wednesday, February 24, 2010 8:39 PM

All replies

  • Excel might open in Read only mode if you click on it.
    Incase you want to modify it, hover on the file, click on "Edit in Microsoft Excel" in the dropdown.

    Thanks!
    I LOVE MS..... Thanks and Regards, Kshitiz (Posting is provided "AS IS" with no warranties, and confers no rights.)
    Wednesday, February 24, 2010 11:22 AM
  • Hi Kshitizs,

    I wanted to know is this default behaviour that office files opens in read only mode by defalut, even if you are the owner of the file(i.e you have created and uploaded the file in Sharepoint site)



    Br,
    Anitha Vyas
    Wednesday, February 24, 2010 12:17 PM
  • Yes, As I see in the following URLs:
    http://social.technet.microsoft.com/Forums/en/sharepointcollaboration/thread/d7b0aa02-e9bf-492c-9311-47db4a895b77
    http://www.eggheadcafe.com/software/aspnet/28381601/readonly-was-displayed.aspx

    I LOVE MS..... Thanks and Regards, Kshitiz (Posting is provided "AS IS" with no warranties, and confers no rights.)
    Wednesday, February 24, 2010 1:33 PM
  • Anitha,

    Try this KB and let me know if this fixes it for you. There is also a registry entry that can be tweaked to open files in read write mode but I would not recommend that since one it involves configuration on each individual machine and secondly ur machines might get hosed coz of registry entries being incosistent.

    http://support.microsoft.com/kb/287402
    Wednesday, February 24, 2010 8:39 PM
  • I know this is an old post - but to fix this type of "read-only" issue we had with many users trying to edit Excel Spreadsheets from Sharepoint, we did the following in office 2010:

    1.  Open Excel
    2.  Click File
    3.  Click Options
    4.  Click Trust Center
    5.  Click Trust Center Settings
    6.  Click Trusted Settings
    7.  Click the Check box to "Disable Trusted Documents"
    8.  Click Okay

    Hopefully this helps for those looking for the obvious solutions.

    • Proposed as answer by Staycd Tuesday, November 27, 2012 3:33 AM
    Tuesday, November 27, 2012 3:33 AM
  • What impact does this have to security? Does it allow macros to run automatically if they are configured to run on "Open File?"
    Wednesday, March 27, 2013 9:06 PM