Excel 2010 with Sharepoint 3.0 Edit or ReadOnly Prompt

Posted on 2014-08-27
Last Modified: 2014-08-27
We're running Sharepoint 3.0 on the server and Office 2010 Professional Plus on the workstations.

On all but one workstation, you can navigate the intranet site, click a link for an Excel document, and it brings up a prompt saying "You are about to open.... How would you like to open this file: Read-Only or Edit"

On ONE computer, it does not give this option at all, but instead opens it automatically in Read-Only mode.  The user can then click the Edit Workbook button in the ribbon bar near the top to edit.  The user with the different Excel behavior has the same permissions to the file as everyone else.  He cannot remember to push the Edit Workbook button before he starts editing the workbook, and it apparently causes him to lose work.  We need to fix it, to give him the prompt on how to open the document.   I've searched around Google and haven't found

Here is how it's supposed to look when you press the link:
Instead it skips the prompt and goes straight to read-only:
Any suggestions will be greatly appreciated.
Question by:vudoox
    LVL 31

    Accepted Solution

    I used to see a lot of questions about this, but there wasn't a single cause.

    There's this;

    There's the need to add the Intranet into the trusted zone in IE.

    There's a registry hack needed in some cases (but I dont think this is your issue);

    One other question, is Excel 2010 being used by everyone?

    Author Comment

    Yes, the same version of Excel is used across the board.  I'll try your suggestions and let you know if any of that works.  Thanks for the suggestions.

    Author Comment

    The first link to the Microsoft KB, it seems like that might be something to try if all users had this problem, but this is only one user with the problem.  The second link doesn't seem to help either.  There is no HKLM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\Web Extender Client\ registry hive.  There is Web Server Extensions but no Web Extender Client.

    Any more suggestions will be appreciated.  I have a hunch it's an Excel setting on this guy's workstation, but I haven't found that setting yet.

    Author Closing Comment

    You were on the right path with the Trusted Zone.  The site was actually in the trusted zone, but I found that other workstations had it in Local Intranet, so I moved it to that zone for the problem user and it's behaving as desired now.

    Thanks for your help!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now