.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 opening excel files stored in SharePoint 3.0 from VS2010 (TFS2010 setup)

Posted By:      Posted Date: October 03, 2010    Points: 0   Category :SharePoint


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

View Complete Post

More Related Resource Links

Error when opening Excel document from 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.


Sharepoint seeking authentication when opening Word / Excel files from website


The company I work for is using SharePoint as a CMS for it's public facing website. I recently enabled FBA (Forms Based Authentication) for the site in order to provide some user specific functionality, but this has caused a side effect with Word / Excel files when opened from the site using Office 2007 / 2010.

Some users are challenged for authentication when opening a Word / Excel document from IE (but not when they're select "save file" instead of "open file"). A window pops up behind IE / Word / Excel (so you often don't realise it's there) showing the sites login page. If the window is dismissed then the document continues to open normally.

It seems to be environmental. Most Office 2007 / 2010 users internally experience this and we've had one report externally of this happening.

Anyone know how to prevent this behaviour?

In case it's relevant: The company also has an internal SharePoint site using NTML authentication allowing internal users to edit the same content visible externally.

I originally suspected the SharePoint header added to responses may be alerting Office to check for authentication to allow extended functionality, but I remove the response header in IIS and it didn't make any difference.


Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

Not always prompted for read-only or EDIT mode, when opening files with IE7, Sharepoint 3.0

Hello Everyone,   We use Sharepoint 3.0 and when I click on a document I get a pop up prompt that asks me whether I want to open the file in READ-ONLY or EDIT mode.   I use a machine with XP Pro that is running IE7.   A user called me today, also running IE7, and when he clicks to open a Sharepoint file he gets a different prompt - a simpler one that just offers OPEN or SAVE.   I don't care that his prompt looks different - the problem is that he is able to open the file, make edits, but then when he closes the file (using Excel) he isn't able to save his changes.   Excel only provides a save-as option for him.   This isn't a permission problem with his ID.   When I login to our Sharepoint 3.0 system as him, with his password (from my machine), I get the usual Read-Only / Edit prompt and when I open a file in EDIT mode I am able to save my changes with no problem.   Any thoughts on this?   Chris

Sharepoint Setup Error

I am installing MOSS2007 on Server 2008 and am receiving the following errors in my application log: Error1: Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (0e3d32ba-5963-4d69-85bd-9857b945dc8b). Reason: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Techinal Support Details: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) at Microsoft.Office.Server.Search.Administration.SearchApi.RunOnServer[T](CodeToRun`1 remoteCode, CodeToRun`1 localCode, Boolean useCurrentSecurityContext, Int32 versionIn) at Microsoft.Office.Server.Search.Administration.SearchApi.AddApp(Role role) at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.InstallGathererApplicationIf() at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize() at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)   Error 2: Error backing up registry hive to the configuration database. Context: Application 'SharedServices1' Details: Access is denied. (0x80070005)   Warning: Could not import the registry hive into the registry because it does not exist in the configuration database. Context: Application 'bd62e31e-3dcb-4

As a Sharepoint Client are SharePoint data files stored on my local PC unknowningly?

I am strictly a SharePoint user and I access the Sharepoint Server on my client PC.  If I open a file simply to read it while it's on the server (not checking-it our for edit or anything like that) is that file written to a temp file or directory on my PC for any specific period of time.  Example when I veiw the SharePoint file or log off the Sharepoint Server?

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 non-Microsoft files in SharePoint


Hi, I wonder if anyone has any idea on this...? My guess is it's something quite simple.

We're using SharePoint 2007 to store shared documents. Some of the documents are Acrobat PDFs. When I click on them, they open up in Acrobat Reader, when another user clicks on them (from his workstation), they open in a web-page. If he opens up other Office document types (Word, Excel), they open in the application as expected.

If he opens Acrobat on his desktop, and then selects the file from the SharePoint folder, it opens up in Acrobat as normal. Any ideas on what could be the cause of this?

Sorry if this question is rather unsophisticated, I'm not all that technical....

Thanks in advance for any assistance.


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!


Microsoft SharePoint server 2010 encountered an error during setup. One or more required office comp

I am encountering this error during setup. The server previously had WSS 3.0 and the Group Board Workspace. I uninstalled those and installed sharepoint foundation 2010. Initially It was up and running but I was receiving errors trying to load the group space template, so I uninstalled SPF2010. cleaned up the registry pointers to the old WSS3.0 and Groupboard Workspace and tried to reinstall. Now I get the error

Microsoft SharePoint server 2010 encountered an error during setup. One or more required office components failed to complete successfully.

Looking into the issue it appears that setup cannot install the embedded sql server, since the logs indicate a dbwrap error. There are no "pendingfilerename" operations which fixed this problem for some. I tried to install as a farm but it won't allow me to use a local admin account.  I also looked at the sql configurations and the windows internal database is running.

Any ideas how to I can remove the windows internal database and reinstall SF2010?

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.

    setup error sharepoint 2010 Windows 7 product ID


    Windows 7 Pro trying to install 2010 in standalone. I started with an ISO image, burnt it to a cd and copied all of the files here c:\SharePointFiles . manually Installing the prerequisites.

    When I run setup.exe I get the error: The Product ID spcified was not found on your machine

    My config.xml file has this line added: <Setting Id="AllowWindowsClientInstall" Value="True"/>

    I also put in the Product key in the config.xml. I cant seem to find much help online with this error. I tried to copy the config.xml to the same directory as the setup.exe and that did not help either.

    Anyone have any ideas what direction I should take? I have pretty much read this thread to death: http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx and that has not seemed to shed any light on the matter. Anyone? I'm several hours into Googling and still running into the same issue no matter what I do.

    Appreciate any help - Thanks!!

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!!!

SQL Server 2008 r2 - Setup support files - Install error / reading from file


I'm installing SQL server 2008 r2 on a Win2003 R2 x86 system.

After i start the setup, the "setup support files" box begins installing, after a while i get this error:

"Error reading from file f:\1033_ENU_LP\x86\setup\sqlsupport_msi\PFiles\SqlServr\100\Setup\ewbfphdh\x86\Patch\rs2000.msp verify that the file exists and that you can access it."

I've tried another DVD, i've tried a mounted share on another machine...no go....i've tried an ISO file mounted on this server... same error.

Is there any way i can install this "setup support files" from another location? (download)

Is there a switch soo it won't install reporting services? (...i think this file rs2000.msp is from reporting services)





Opening SharePoint List Attachments - HTTP 500 Internal Server Error

Hi All,


We are programmatically attaching documents/attachments to the list item through a web-part.

I'm using the below code to accomplish this. (Fileupload control is rendered in the webpart)

Stream inputStream = this.fileUploadCtrl.PostedFile.InputStream;

byte[] buffer = new byte[inputStream.Length];

inputStream.Read(buffer, 0, (int)inputStream.Length);



spListItem.Attachments.Add(this.fileUploadCtrl.PostedFile.FileName, buffer);



The attachments are getting added fine. But in some cases, only the file is attached but not the contents. when we click on the attached file name, we get the following error:


Has anyone encountered this issue? Any help is highly appreciated.



SharePoint 2010 Error when opening "configuring incoming e-mail settings) correlation ID 5fe3b103-c0


I am runnign a Proof of Concept environment and cannot configure the incoming e-mail settings. When i click on the link in the Administration Console of Sharepoint 2010, I get a error message ERROR"File not found" Correlection ID 5fe3b103-c00b-4d5f-87f5-148fa1ecdb53. Can some one please help with this issue? I can configure the ut going E-mail settings if that helps with troubleshooting the issue.

Any help would be appreciated.

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