.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

Unable to save Excel files opened from SharePoint

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :SharePoint
Hi all!

From time to time users have problem saving excel files that they have opened from a SharePoint document library.

Error message:

"Document could not be saved"

It's not possible to save it localy ither.

Any ideas?


View Complete Post

More Related Resource Links

SQL Server Management Studio cannot save new files to SharePoint folders

If the file already exists I can save changes to the file. But I cannot save new scipt files to a SharePoint 2007 drive.

SQL Server Management Studio cannot save new files to SharePoint folders

If the file already exists I can save changes to the file. But I cannot save new scipt files to a SharePoint 2007 drive.

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.

    Unable to open an Excel File in Sharepoint MOSS 2007


    I am unable to open an excel file in Sharepoint (MOSS 2007). All other documents work fine. As far as I know there was no change on the Server at all.

    Excel found unreadable content in 'stuff.xls'. Do you want to recover the contents of this workgroup? If you trust the source of this workbook , click Yes

    When I click YES >> It says "Excel recovered your formulas and cell values, but some data may have been lost." And then a link to an xml file , which reads :

    <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
    - <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
      <summary>Errors were detected in file 'http://server_name/Project_name/Shared Documents/abc - def/Phase 5/Track/stuff.xls'</summary>
    - <additionalInfo>
      <info>Excel recovered your formulas and cell values, but some data may have been lost.</info>

    Now this has resulted in huge loss of data and I can see New numbers in the cells which is very strange!

    Is there a way I can get it back ? I do not have a

unable to save data in SQL Server database through Sharepoint 2007


Hi All,

I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.

Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.

Can some one have idea on this. Please help me to get it done

Thanks in Advance.

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

Unable to save document back to SharePoint over HTTPS.


We recently created a new SP2010 farm and upgraded and attached content databases to it from SP2007. When I try to edit any word/excel document from the SharePoint through the HTTPS i get the following pop up message box.

"\\sp.xxxx.com@SSL\DavWWWRoot\WMC\IT\Network Engineering is not accessible. You might not have permissions to use this network resource. Contact the administrator of this server to find out if you have access permissions.

Mutual Authentication failed. The server password is out of date at the domain controller."

My name is in the Central Administration --> Manage the farm administrators group. I have Full Control permissions in the document library and almost everywhere on the site.

Error saving Office 2010 files opened from SharePoint Server 2007


I have recently started testing Office 2010 and have found only 1 major issue - I cannot save any Office 2010 files opened from a SharePoint Server 2007 location.  Upon save I receive an error message saying "Upload Failed. This file wan not uploaded because the specified path was not found on the server." and the file is captured in the Microsoft Upload Center.  Using the Upload Center action 'Open Web Site' opens the site without problem; however, a all subsequent resolve actions fail.  Any ideas?


  * MS Windows Server 2003 R2
  * MS SQL Server 2008 R2
  *Office SharePoint Server 2007
  *MS Office 2010 Premium

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.


Unable to save Office 2007 document to SharePoint My Site Personal Documents document library


...also when Office documents are saved to document library they open as Read-only and cannot be saved back to the same document library.

This only happens in my production SharePoint 2007 environment from client XP and IE7 machine.  It does not happen in developement environment (which mirrors production) from client XP/IE7 machines.

Save works fine to SharePoint document libraries from client Win 7 and IE8 machines in both production and development environments.

This only happens when attempting to save to a My Site Personal Documents document library.  Any other document library this behavior does not exist from XP or Win 7 machine.

What settings controls ones ability to save to a personal My site document library.  What setting could be different between prod and dev installations?  It only happens

sharepoint-2010 how to open files that prompt for save or cancel

In SharePoint 2010, there is a new setting at the web application level called Browser File Handling (Fig. 1). You get to this setting with these steps:
.Central Admin > Application Management > Manage Web Applications
.Single-click the row of your web application
.Click General Settings in the ribbon
.Scroll down to Browser File Handling and select Permissive

Browser File Handling settings

By default, this is set to Strict when creating a web application. However, this causes issues in many ways related to opening certain files from SharePoint. The most obvious example is with PDFs. When set to Strict, a PDF can only be Saved (downloaded), but in Permissive mode, the PDF can be opened directly. For instance, here are the different results when clicking on a PDF in a SharePoint 2010 Document Library:

Opening a PDF in Strict mode

Opening a PDF in Permissive mode

As you can see, in Strict mode, I am prompted to Save or Cancel In Permissive mode, the PDF immediately opens without being prompted and in my case, my PDFs open in the browser by default (this is a setting you can change).

Another way this issue manifests itself is when opening versions in an InfoPath form library. Someone posted this issue on the forums, and when I didn''t experience the same issue, I immediately thought of Browser File Handling. Mine was alre

Export SharePoint List to Excel Spreadsheet Programmatically using C#

In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

SharePoint document migration challenges when migrating files and folders

There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.

PrintPocketCE Print Pocket Excel, Pocket Word and email files

Version 3.560 (May 15, 2009):

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.

Adjusted PocketJet printer paper feed commands

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):

Fixed error in Canon printer support

Fixed COM0 port selection

Version 3.556 (June 15, 2008):

Added support for Brother MW-260

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):

Added Panasonic JT-H200PR printer support

Added Pocket Spectrum printer support

Fixed problem with WM5.0 "inverted image" problem

Microsoft Office Excel cannot open or save any more documents because there is not enough available


hi all,

     i am new to asp.net programming i am trying to create an ms excel file with charts drawn in it,

i wrote the complete code for it but the it is saying

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. 

i have set the permissions to my complete disk space and all user accounts, and i tried with anti-virus disabling also it didnt work please try to help me out and my code is :

Imports System.Data.OleDb
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Tools.Excel
Imports System

Excel Interop Save as



I want to Save excel workbook using Excel interop in 97-2003 format. Currently I have Office 2007 installed on my machine.

below is the code I am using.

_book.SaveAs("New.xls", Excel.XlFileFormat.xlWorkbookDefault, Missing.Value, Missing.Value, false, false, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

The solution is little urgent.


System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot open or save any mo


Hello good people, 

I have this beast as an error. Did my research and found some posts here as well but did not do any good for me. 

Here is what I did. I had an error regarding issue rights with COM objects so I gave access rights under component services for Microsoft Excel application now I am getting this error. 

Here is some information regarding this

1. Gave rights to ASPNET and network service to my web app directory to try to fix this error. 

2. The exact same process works on my Windows 2003 server and my Windows 7 development machine. I am trying to get this going on a different windows 2003 machine that is outside of our domain.

3. Developing on windows 7 64 bit with office 2010 installed. Also excel 2010 is installed on my Web server

4. Here is the code that is causing the error: The last line is causing the error.:

            MyXl = new Microsoft.Office.Interop.Excel.Application();
            MyXl.Visible = false;
            MyWb = (Microsoft.Office.Interop.Excel._Workbook)(MyXl.Workbooks.Add(Missing.Value));
            int test = 0; 
            MySheet = (Microsoft.Office.Interop.Excel._Worksheet)MyXl.ActiveSheet;
            if (reader.HasRows)
                int InRow = 2; 
                for (int i = 0; i < Nu
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