.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

Cannot Publish Excel 2007 workbook to Report library on MOSS 2007 Sharepoint

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


I use Windows 7, trying to Publish an excel workbook to MOSS 2007 Report Library. When I type the location in the "Save As.." dialogue, It disappear & file is not saved.

If I do the same from Windows XP OS with Office 2007, I get the Report Library content (the sp folderrs), so I can navigate & file is published succesfuly

Please help :-)


View Complete Post

More Related Resource Links

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

Not able to edit the document in a SharePoint (Moss 2007) document library


Not able to edit the document (Office 2007) in a SharePoint document library, Its showing already checkout (locked for other users) by another user still that is checked-in and also if checked-out even the same user cheked-in. Please provide me the solution.




not open excel 2010 file template in moss 2007 document library


I have installed microsoft sharepoint portal server 2007.

In which I specify in one document library excel template. I upload template of excel 2010

if OFFICE 2007 is installed in my system or in other persons . then it will open a template in excel document . but I update office and now office 2010 installed in my system. now when i click a new button and open a excel document . it is not opening and open only a text file with garbage. and show a dialog box with message.


"The document could not be created.

The required application may not be installed properly, or the template for this document library cannot be opened."

How can I open a template in office 2010 with MOSS 2007 document library.

Kindly tell me the solution as soon as possible.



Basim Alvi

Display the Version of a MOSS 2007 Sharepoint document in Word 2007 and Excel 2007

Do somone have a step-by-step solution to this problem;   I have a liberary in SharePoint with version controll. In this liberary I have both Word and Excel documents.  Displaying the metadata from created columns are no problem, but  displaying the Version of the document generated by SharePoint is worse.  I do appreciate if someone can help me with this problem.

Can't see any data after publish SSRS report to Sharepoint 2007



I'm using SSRS 2008 R2 , MOSS 2007 and report Builder 3.0 To generate cascading reports with sharepoint 2007 lists.

I'm able to filter and see the data correctly within report builder .

But if i upload the same RDL file to Sharepoint library and then tries to view the report,i'm not getting any data.(absolutely zero records) 

I'm using Report builder 3.0 and sharepoint list as connection string.

Interestingly, if i'm ising XML as a connection string to pull sharepoint list data and then publish the report to sharepoint, i'm able to see the data within sharepoint correctly and i'm able to use the cascading filter and can view the correct data.

Please advice on why i'm not able to see the data if i'm using the connection string" sharepoint list "

This issue is same even if i'm using BIDS 2008 and sharepoint list as connection string.

i would like to use sharepoint list as connection string because of the ease of using it.

Thanks in advance!!


Best Regards, Ashok Yadala | Senior SharePoint Consultant

MOSS 2007: Automate Web App Deployment with the SharePoint API


Learn how to automate custom SharePoint application deployments, use the SharePoint API, and avoid the hassle of custom site definitions.

E. Wilansky, P. Olszewski, and R. Sneddon

MSDN Magazine May 2008

Unable to open pdf from document library MOSS 2007


When I click on a pdf document uploaded in a document library it comes up with a blank page. 

I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.

I tried other browsers too, it's the same issue.

I am able to open all other pdf files local to my machine fine.

I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.



In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Cannot locate Tsneu.xml to Configure SharePoint Treasure (Synonym) In MOSS 2007


Hi all,

I wanna follow this article -> http://www.codeproject.com/Articles/36203/How-to-Configure-SharePoint-Treasure-Synonym-In-MO.aspx?msg=3038555 

to figure SharePoint Treasure (Synonym) In MOSS 2007.


I created the SSP for searching file, and my SSP guid is 7xxxxxx-xx etc., but in my MOSS 2007 server,  

I have this folder -> "Drive:\Program Files\Microsoft Office Servers\12.0\Data",

but no I haven't "Drive:\Program Files\Microsoft Office Servers\12.0\Data\Applications\" folder, so I cannot locate Tsneu.xml as above article.


I can find "tsneu.xml" file in following 4 folders, I don't know which file I should modify... 


SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

Sharepoint 2007 and Excel 2010 features


Does Sharepoint 2007 Server support the new Excel 2010 feaures like slicers? Or do i have to have Sharepoint 2010 to get that working (considering all other components besides Sharepoint 2010 are available in my Sharepoint 2007 environment) ?

- Thanks



When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open


When try to open a folder in a moss 2007 document library in Explorer View, the folder does not open.

I am using IE7 and the path of the folder does not contains more than 100 characters.

Also it opening on few on the machines which has IE7.


What is the best way to Create Ageing Report in SharePoint 2007?


Hi Experts,

I need your point of view about this and please advise,

My client have made a request to generate Ageing Report thru their SharePoint 2007, FYI all invoice was scan and upload to sharepoint and save as PDF file under Document Library. During the scan, certain information will capture automatically and save it into field that we defined inside the Web Form.   

Below is the basic input we capture:

Vendor Code, Vendor Name, Invoice Number, Invoice Date, Currency, Invoice Amount

Report Requirement (display list and group of:)

- Vendor Code, Vendor Name, No. Of Invoice, Total Payable, Ageing 0-30, Ageing 30-60, Ageing 60-90, Ageing>90 

So my question is, what is the best platform to create this Ageing Report??

because when i try to design the report thru Visual Studio (Reporting Services), i can't identified which database should i connect and which table is store all the invoice information in SharePoint.

Any idea guys?? anybody have implemented it before??


Issue With MOSS 2007 Picture library



We have a MOSS 2007 publishing portal. We are currently facing issues with Picture library created with default picture library template.Whenever we have tried to upload an image to the picture library I am getting "acess denied" error message, though I have full permission to the site level as well as to the library level.I have seen the pictures are getting uploaded and in "checked out" state.It does not show the "edit properties" page on upload and does not even allow the owner of the image to edit the properties, gives the same access denied error message.

I have also tried to check in the image files through the "management and content structure", but the images are not getting checked in. Please let me know the root cause of this and how we can resolve this.





Chapter 8: Advanced SharePoint Programming, Part 1 (Expert WSS 3.0 and MOSS 2007 Programming)

Learn about web configuration modification via SharePoint object model and extending the STSADM command-line utility in this book excerpt.

Chapter 8: Advanced SharePoint Programming, Part 2 (Expert WSS 3.0 and MOSS 2007 Programming)

Learn about SharePoint feature receivers, developing custom timer jobs, feature dependencies, and feature stapling in this book excerpt.

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