.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error when opening Excel document from sharepoint

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :SharePoint

Hi, I am using Sharepoint 2010 and Excel 2010 x64.

I created a document library where I host a simple excel file for testing. When I click on it , it opens in the web browser just fine.

When I chose to open it with Excel , I get this error : The document could not be opened for editing. A microsoft Sharepoint Foundation compatible application could not be found to edit the document.

I already tried as well to do a check out before opening it and it still doesn't work.

Any ideas ?

PS : same thing happens with Visio 2010.


View Complete Post

More Related Resource Links

Error opening excel files stored in SharePoint 3.0 from VS2010 (TFS2010 setup)



First I hope this is the correct forum for te below question, and if not, please excuse and if possible divert me to the correct place.

We have a TFS2010 setup with (what I managed to identify) Sharepoint Services 3.0.
We have 2 users working in the same collection, and also share some of the projects in it with the below problems:

1. User A has Office 2007. She is unable to "edit workbook" on an excel file directly from VS2010, and gets an error of 'Unknown error trying to lock file'. I searched this around and didn't find a solution, but did find a workaround - If she checks out the file directly from the SharePoint site, she is able to edit the file, and in fact is able to later "edit workbook" directly from VS2010 (as long as she once checked it out through SharePoint).

2. User B has Office 2010. When he tries to "edit workbook", he gets an error of 'A problem occurred while connecting to the server. If the problem continues, contact your administrator'. When he goes directly to the SharePoint, he is able to check out the file, open it in Excel 2010, but is not able to check it back in (gets an error that the file cannot be located or so, I don't have the exact error). This means that this user cannot work with the SharePpoint stored files at all, and currently works on local copies on hi

The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' error on 2nd SharePoint server in farm

We just added a 2nd SP2007 server to mirror our site.  The original site is in China, the new site in the US.  They are connected via a permanent  site to site VPN.  We are hitting the errors when attempting to upload files to the US mirror.    Environment: US server site: OS: Windows Server 2008 R2 Enterprise (64 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (64 bit) DB: Windows SQL Server 2008 Enterprise R2 (64 bit) China site: OS: Windows Server 2003 Enterprise SP2 (32 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (32 bit) DB: Windows SQL Server 2008 Enterprise R2 (32 bit) Background: We setup two test Sharepoint farm to be syncronized with only its content database. The upload works good on SZ site. But we got the following 2 error messages randomly when uploading file to document library of SF side. Error message: 1. The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' is invalid.  It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web. 2. Cannot open file "ao/AO Document/Admin Guideline/xxxxx.jpg". -- We've tried the official hotfix, altering the schema, changing the IIS memory limit settings, and restarting the application pool. Could the issue be related to the different OSes 2008 vs 2003, or 32 vs 64bit?  

WSS2.0 opening pdf documents an error message appears: The document could not be saved. The file may

Hi All,. In a WSS2.0 document library, a user is trying to open pdf files. However, an error message is displayed: 'The document could not be saved. The file may be read only, or another user may have it open. Please save the document with a different name or in a different folder'. No one else has the file open. When the user saves the file using Save As (as it is apparently Read Only) and then saves the file back to the SharePoint site, all previous versions of the file disappear. The user has noted that this has been happening since today, and she had some other network issues that have been resolved. No other users are experiencing this problem.  Not sure if this problem is related to the network problems the user was facing. I've had the user reboot but this has not resolved it. Any ideas?

Opening an xlsx document in SharePoint 2010

Hi, please can you help? We have SharePoint 2010 installed and using Internet Explorer 7 along with Microsoft office 2007.When a user attempts to open an uploaded excel document (xlsx), an error message is displayed as below The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser: • Data validation Would you like to try and open this file in Excel? Learn more about unsupported features If the user, then opens and then closes the document, the screen does not return to the user's site. This is not the case with an xls document. If you can assist in pointing me in the right direction, i would be very greatful. many thanks in advance Alec

Script error when opening document menu

Hello,   Two of our MOSS users found strange problem when they tried to open or edit document in document library. When they try to open document menu, IE gives error:   Internet Explorer Script Error Line: 578 Char: 1 Error: Object expected Code: 0 URL:  http://<servername>/<sitecollection>/<site>/<documentlibrary>/AllItems.aspx   Do you want to continue running scripts on this page? Yes / No   Can anyone help me what to do? Users cannot do anything with documents now.   Best Regards Toni

Document is read-only in SharePoint, but user sees "check out" option in Office 2007 / Word / Excel

I am finding that when there is a document library in SharePoint with checkin/checkout required, if a user with read-only ("Visitor") permissions opens a document from that library, the document will open as read-only in Word, Excel, etc., but the user will see the "Server Document" bar with the message "To modify this document, you must check it out" and the "check out" button.  When the user tries to check the document out, they are asked to authenticate, and then receive the error "Cannot perform this operation.  The file has been deleted or someone else has it checked out."    How is it possible to prevent a user with read-only rights in SharePoint from seeing the "Check out" option in Word or Excel?

ASP:Upload control . Uploading into a SharePoint Document Library Subfolder and FILE NOT FOUND error

RE: ASP:Upload control . Uploading into a SharePoint Document Library Subfolder and FILE NOT FOUND error Two Issues, apparently unrelated. I have subfolders like this /ApplicantDocuments/20 and /ApplicantDocuments/21 (where 20 and 21 are my subfolders and ApplicantDocuments is my library. 1. The below function is erroring with file not found, but I confirmed I'm sending the fully qualify path (i.e c:\test.txt) to System.IO.FileStream content = System.IO.File.Open(documentFileName, System.IO.FileMode.Open); 2. Even if it worked, looking at the code, I'm not using argument foldername.  I'm passing 20 to the argument. How can I make sure it uploads into subfolder 20 of ApplicantDocuments? Thank you.     Just testing in test environment. Will tighten code once it works.   public void UploadDocumentToSite(string foldername, string documentFileName) {      SPSite siteCollection = new SPSite("https://xxxxxx");      SPWeb web = siteCollection.OpenWeb();      //SPSite.AllowUnsafeUpdates = true;      //Web.AllowUnsafeUpdates = true;      string Lib = "ApplicantDocuments";      SPFolder destFolder = web.GetFolder(Lib);      sendmail(documentFileName+" "+foldername);  

InfoPath / ActiveX error when using person selector field in Word template off SharePoint document l

I have created an out-of-the-box document library on a SharePoint 2010 site.  I left Microsoft Word Document selected as the Document Template.  I then added a person or group column and a multiple lines of text column to the document library. I then went into Library Settings --> Advanced Settings and clicked on Edit Template, opening the template in Word.  I created my template and added the two new columns to the document.  I did this using the Quick Parts --> Document Property --> [column name] feature under the Insert tab in Word.  I then saved the template back to SharePoint. Upon opening the template or creating a new document from the template, I get the following dialog box: --------------------------- Microsoft Office InfoPath --------------------------- One or more ActiveX controls could not be displayed because either: 1) Your current security settings prohibit running ActiveX controls on this page, or 2) You have blocked a publisher of one of the controls. As a result, the page might not display correctly. --------------------------- OK   --------------------------- I've searched around (I believe fairly extensively) and have not run into anyone else with the same issue.  Some have mentioned a similar error when creating a custom document information panel in InfoPath, and suggested lowered ActiveX security setti

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

Error occuring while exporting larger reports to Excel from SharePoint



I have SSRS configured in SharePoint integration mode. I have reports deployed. if a user wants to export the report to an excel file works fine for smaller reports. But, in the case of larger reports it is throwing me an error while doing export to Excel. I am getting message like

An unexpected error has occured.

Example: Monthly reports are exporting to excel file fine. Where as, Yearly report has more data than the monthly reports. If I try to export these reports, I am getting above error. I must sure, this is something to do with the IIS time out or application time out(setting in web.config file of web application). Please some one guide me where is best place to do this.

Viewing works fine for both the reports.

I appreciate your help.



Opening pdf from Sharepoint 2010 Document Center


Is there a way to open a PDF in a web browser, just like Office Web Apps?  Everything I've tried results in the PDF being saved first.  I do not want to save these files, I only want to view them.



Error opening an excel file

I'm getting this error while trying to open an excel file from my application. I tried this http://blog.crowe.co.nz/archive/2006/03/02/589.aspx but it didn't help. Excel itself opens normally, but it does not from my application. here is a screenshot of my code:
        case "xls":
          System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("ru-RU");
          Microsoft.Office.Interop.Excel.WorkbookClass wb = new Microsoft.Office.Interop.Excel.WorkbookClass();
          wb.Application.Visible = true;
          wb.Application.Workbooks.Open(fileName.ToString(), updateLinks, readOnly,
            missing, missing, missing, missing, missing,
            missing, missing, missing, missing, missing,
            missing, missing);
I didn't find a solution in another threads. Please help me... this option is cruicial in my application. Thank you!


Error Message PowerPivot Excel on SharePoint : "Excel was unable to get necessary information about


Hello everybody:

I get the error message “Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server” when I open the excel on the sharePoint site and the PowerPivot Datasource is already refreshed successfully on schedule.

I describe my steps more clearly.

  • Step1. Create Excel pivot tables and charts by using PowerPivot datasource which connects to SQL Server.
  • Step2. Publish Excel to SharePoint site. The Analysis Server will build a PowerPivot cube in "VertiPaq" StorageEngineMode automatically and the cube name including an "uniqueindentifier" in the end.
  • Step3. Schedule PowerPivot refresh plan on SharePoint and the successful result comes out soon. After PowerPivot refreshed the "uniqueindentifier" will be changed to another one automatically.
  • Step4. When I open excel on the SharePoint I will get the error message again. If I click the "ok" then Excel will really Refresh.

Now I have tried two ways:

  1. Locale setting: Doesn't work. It seems not to be the cause of my problem because it won't happen if my excel's datasource is connecting to DB or Cube directly.

    Visio & Excel serivices error during display document


    Hi, all!

    I have allready installed and configured SP 2010 Enterprise. Configured Excel and Visio Services (created services, configured Application ID for external data). Then activated enterprise features on my site collection and add excel and visio documents to document library.

    When I try to view them in browser I get error: server can't process request .

    This problem disapeared in my developer server after I have installed MS Office Excel and Visio on my server. Should I do that for my product server or there are other way to solve this problem?

Opening SharePoint List Attachments - HTTP 500 Internal Server Error


We are getting "HTTP 500 - internal server error" upon opening list attachments. The list attachments are added programmatically to the list item.

This doesn't happen for all the items in the list, but only for few items.

There is no error in the SharePoint logs and the event viewer.

Has anyone encountered this issue/error?

Visual C++ Runtime Library error when opening documents in Powerpoint 2010 from Sharepoint link



I posted this question on the Office Powerpoint forum and did not get much response so thought I would try here.   Here is the link to that post  http://social.answers.microsoft.com/Forums/en-US/pptshare/thread/36a58d07-b1ad-4935-a14e-086dae8cb786

I'm running Windows 7 with Office 2010.  We have a Sharepoint 2007 server.  Whenever I click a link from our Intranet site I get the error "this application has requested the Runtime to terminate it in an unusual way.  Please contact the applications's support team for more information."  It asks if I want to open in safe mode and I say yes and it never opens. 

During testing I also find that if I have a blank powerpoint .ppt file that I try to save to the same document library on the same site it works fine, but if I try to save a blank .pptx file to the site I get the same runtime error. 

This does not happen on all powerpoint or office documents being opened from the Intranet.  If I boot to safe mode it works fine.    If I copy the files local they work fine.  Any ideas on how to fix it?

Thanks so much!!!

Opening Word 2003 document from sharepoint site in word 2010.


When using sharepoint services with word 2003 on an XP machine, everything works fine. We bought some new computers where we now have windows 7 and office 2007/2010. These work perfect too. Even the 64-bit computers.

We are very happy with the new office version, so we decided to upgrade the entire company. As a test, we upgraded 1 PC. But this is not working. So we upgraded office, later we reinstalled it. But nothing helps. This is the problem: I surf to the document click it to open it, and then Word hangs. "contacting server". This is not always the case, sometimes it works, sometimes it doesn't. This even with the same document.

We would really like to upgrade to office 2010 entirely. But we're not going to buy licences we cannot use. Anybody got a solution?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend