Learn how to a build a cloud-first strategyRegister Now


Excel 2010 with Sharepoint 3.0 Edit or ReadOnly Prompt

Posted on 2014-08-27
Medium Priority
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
  • 3
LVL 32

Accepted Solution

Jamie McAllister MVP earned 2000 total points
ID: 40288034
I used to see a lot of questions about this, but there wasn't a single cause.

There's this; http://support.microsoft.com/kb/2018958

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); http://blogs.msdn.com/b/bmatusz/archive/2008/12/10/office-2003-documents-opening-as-read-only-from-moss-2007-document-libraries.aspx

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

Author Comment

ID: 40288096
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

ID: 40288215
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

ID: 40288288
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


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

810 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