Recent update: 2008-3-21
Hi, I have used FORM Authentication in my application. When i try to view the Excel Web Access webpart it gives the error "Unable to delegate credentials. Please modify Excel Services configuration to be consistent with Windows SharePoint Server [User: ...
Hi, I was getting this error whenever i try to refresh my Excel webpart. I tried running stsadm commands listed at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1254993&SiteID=1 This has further enhanced the problem. Now the webparts don't even load. I am getting "Please ...
I uploaded an xlsb file to the Sharepoint 2007. The file contains pivot table tab (with dril down option) along with a raw data tab (with freeze panes). Upon connexting the file to the excel web services – the drill down option disppears as well as the freeze panes. Any idea if it is possible ...
I have created a Site collection in Sharepoint 2007 and Extended it. Now , i can successfully view the Excel sheet from this site. But when i have a SQL user authenticate and log in, and when i click on the same Excel Web part , i get this error message :" Excel Web Access : An error has ...
247 byte By
lokia at 2008-3-1
Hi, I have a Excel spreadsheet and we have a requirement to write the data from that sheet into a SQL server database. How this can be done using excel services. Any pointers to this will be really helpful. Thanks in Advance. -Lokeya
Hi, I've created simple UDF following the post: http://blogs.msdn.com/cumgranosalis/archive/2006/08/03/ServerClientUDFsCompat1.aspx and I've got my UDF working on SharePoint. I can open workbook in a web browser, change parameters, recalculate and it works fine. Then I’ve decided to add COM ...
Hi All, I'm trying to get an excel chart to update in excel services when the pivot table that it is based on is drilled into. The chart updates in the Excel environment but not the excel services. Is this possible, and if so can someone please tell me how to do this? TIA, Grant
I have the following worksheet configuration being viewed through a EWA part:Chart gets data from Worksheet gets data from UDF Array Formula gets data from SharePoint ListI cannot get the chart to display properly, i.e. it is not pulling data from the worksheet and renders empty. If I view the ...
334 byte By
AfterA at 2008-2-25
i use ms sharepoint server beta and ms office enterprise2007.when i publish excel to i get error "The server rejected this file because the format is unknown or corrupt."plese call me what'll i do.thanks a lot. ...
Hi All, I want to know how to auto schdule my excel files in Excel services and sharepoint server 2007.is there any provision given by sharepoint server 2007 to schdule the files.somebody can help on this. Thanks&Regards, Amar..
Hi,We have couple Excel files which are link each other for calculating values. Now we want to use Excel Service so that we can show the data to users based on their credentials. We know that Excel service won’t support external excel links.so we want to use following scenario, correct me if ...
Hi,I've created simple UDF following the post: http://blogs.msdn.com/cumgranosalis/archive/2006/08/03/ServerClientUDFsCompat1.aspxand I've got my UDF working on SharePoint. I can open workbook in a web browser, change parameters, recalculate and it works fine.Then I’ve decided to add COM part ...
I create a Document Center site and add a Document library named excelServiceSample to store excel document The location of excelServiceSample is :" http://vistaserver:27490/sites/bj/Doc/excelServiceSample" And I create a "Trusted file location" and assign the address to ...
Hey,I try to make a KPI indicator on a uploaded excel file. But somehow i cant. I tried everything different files office 2003 and office 2007. The thing is when i try to fill in a cell adress by clicking on the excel icon at the right of the form it gives a error. The error is in dutch saying ...
I'm not a Sharepoint developer nor am I an Office developer. (just a plain ol' .Net web developer.)I'm interested in providing a fully functional excel workbook interface to my web application users (I suppose this means via a browser) . The following are the stories that I'd like to ...
I have several SharePoint test pages that are utilizing Excel in one way or another - via a KPI List or an Excel Web Access webpart. All were working fine yesterday. Last night, an automatic MS update took place to my machine (Windows Server 2003) causing it to reboot and now everything ...
When attempting to view an Excel spreadsheet in SharePoint, we get the following error displayed in the web browser:Excel Web Access: An error has occurred Checking the Event Log we see: There was an error in communicating with Excel Calculation Services ...
I have to configure Excel Services on my SharePoint single server. My test workbooks with connection to a SQL server works fine in Excel web access web-part.But I have some problem when I'm using connection to SharePoint list (PivotTable). The problem is that I can't refresh external ...
Hey,I try to make a KPI indicator on a uploaded excel file. But somehow i cant. I tried everything different files office 2003 and office 2007. The thing is when i try to fill in a cell adress by clicking on the excel icon at the right of the form it gives a error. The error is in dutch saying ...
I have to configure Excel Services on my SharePoint single server. My test workbooks with connection to a SQL server works fine in Excel web access web-part.But I have some problem when I'm using connection to SharePoint list (PivotTable). The problem is that I can't refresh external ...
2651 byte By
Hynkel at 2008-2-15
We are having some issues regarding Excel Services. For example; from a SP document list trying to open an Excel Workbook using Excel Web Access simply results in an error with the text "An error has occurred." On the SharePoint 2007 server running Shared Services I look into the ...
3068 byte By
PriyaG at 2008-2-15
Hello,Snenario : Created a worksheet(report) in Excel 2007 and Excel Services using .ODC file.The .odc is created(SQL database) and registered in a trusted DCL in SharePoint.The connection file is also exported to the SharePoint using Export Connection File in Connection Properties in the ...
Hi When we create a pivot table with a report parameter in an Excel Workbook, the report parameter shows an option as to whether to allow selection of multiple items in the report parameter. If I uncheck the option "Select Multiple Items" and publish the workbook in Excel Services, I ...
I'm having a problem getting my external data provider to work in Excel Services. I just went through this process (following a video tutorial)* Created a DCL in Sharepoint* Set the DCL up as trusted for Excel services* Made sure my doc library was trusted for Excel Services, and that the ...
Hi,I am using Sharepoint 2007 Beta Release and Excel 2007 Beta Release.I am trying to publish Excel spreadsheet to a document Library but I always get "Document not saved" error message.PL. find below the steps that I have followed to publish the Excel:1) Checked to see that Excel ...
Hello,I have developed a simple UDF that fetches some information from a database, and returns it as a bi-dimensional array. The number of rows can be from 10 to 20. If only 10 are returned, I get #N/A in all the empy cells. I want them to be empty if there is no value, and I don't want to ...
I have created an Excel file and I use the Publish option in Excel 2007 to publish it to the server, into a doc library that I have created and set up as a trusted location for Excel Services, but when I go to look at the library, I don't see the document I just published. If I use the Upload ...
Hi,I posted the third post about how to get client-server compatibility for server-style UDFs.The new post is at: http://blogs.msdn.com/cumgranosalis/archive/2007/03/07/ServerClientUDFsCompat3.aspxThe first two posts in the series are ...
Hi All, I'm trying to get an excel chart to update in excel services when the pivot table that it is based on is drilled into. The chart updates in the Excel environment but not the excel services. Is this possible, and if so can someone please tell me how to do this? TIA, Grant
Hi,I′m deploying Excel Services through Sharepoint web parts.My costumer wants to show different content in another web part according to the cell selection in the workbook showed in the Excel web part.I just want to make Excel Web part not only consumer of other sharepoint web parts but a ...
Hi Is it possible to enhance the functionality of Existing Excel web access webpart Basically i want the cells to be editable so that the data change can be reflected in the pivot chart Is this possible? Regards Abhijit
1870 byte By
Marin at 2008-2-10
We are deploying SQL Server 2005 with Analysis and Reporting services. This deployment is still in test/development phase. At this point I am stumbled at publishing an Excel 2007 pivot table (linked to the SQL 2007 AS data cube) on the SharePoint 2007 server. I can publish a pivot table, but ...
Hello I have a question about loading to Excel Services. Is there any way that I can load data from a Project Portfolio Server 2007 or Project Server 2007 to an Excel Service and display that data in SharePoint Server 2007? Thanks and best regards, Mystique
I am trying to debug a UDF running under sharepoint. I have attached to the right w3wp process under which the shared services is running.When I attach to the process, it doesnt load the symbols for my UDF assembly. I have my PDB's in the same location as the UDF.'w3wp.exe' (Managed): Loaded ...
869 byte By
spnz at 2008-2-7
Hi there,I am hoping someone can point me in the right direction.We have 3 servers. Our main server and then 2 other Virtual servers that host our sharepoint server and our SQL server.Everything is working ok except our excel services. We have created all of our trusted locations,connections ...
Hopefully, someone can help me. I have a web part calling out to the Excel Services web service (code appears below). I am simply trying to return the value from a cell, but I can't even get the file open.I am getting the FileOpenAccessDenied exception, even though the user is a site owner for ...
385 byte By
Snehil at 2008-2-7
HiI am trying to export to Excel from a Shapepoint list using "Actions"->"Export to Spreadsheet" option. But, I am getting this error "Cannot get the list schema column property from the Sharepoint list".After which I do not get any data in the excel sheet.Is this probl...
Hi All,We have two virtual machines set up, one with Sharepoint 2007, the other with SQL server 2005. I'm having a lot of trouble trying to get a dashboard page set up to work properly. I have created a number of PivotTables within Excel 2007 as well as an ODC. From the desktop of my client ...
2204 byte By
PriyaG at 2008-2-7
HelloI have been trying to use managed UDF for the Client (as Add-In) and Server excel workbook on sharepoint server.I have followed the site http://msdn2.microsoft.com/en-us/library/bb267252.aspx which explains "Extending the Excel Services Programmability Framework".1. Created a UDF ...
1586 byte By
PriyaG at 2008-2-6
HelloI have created a COM Interop managed UDF in the sharepoint server and deployed it as an add-in for the Excel workbook.The excel workbook is placed in a trusted file location and the UDF is registered as a trusted UDF with sharepoint.I have followed the ...
I create a Document Center site and add a Document library named excelServiceSample to store excel document The location of excelServiceSample is :" http://vistaserver:27490/sites/bj/Doc/excelServiceSample" And I create a "Trusted file location" and assign the address to ...
Hi !I created a workbook that have a pivot table with page filters against an SSAS cube .Then I published it in Excel Services setting those page filter (by naming the cell with the page filter value) as parameters. In MOSS I exposed the workbook through an Excel services web part and also ...
Hi !I created a workbook that have a pivot table with page filters against an SSAS cube .Then I published it in Excel Services setting those page filter (by naming the cell with the page filter value) as parameters. In MOSS I exposed the workbook through an Excel services web part and also ...
Hi Is it possible to enhance the functionality of Existing Excel web access webpart Basically i want the cells to be editable so that the data change can be reflected in the pivot chart Is this possible? Regards Abhijit
Hi,I am trying to access the excel services API of a project workspace site created through project web access and am not able to add the web reference even though the workspace sites exposes the webservice and methods.The following error is given in the web service description box:<<The ...
1870 byte By
Marin at 2008-2-4
We are deploying SQL Server 2005 with Analysis and Reporting services. This deployment is still in test/development phase. At this point I am stumbled at publishing an Excel 2007 pivot table (linked to the SQL 2007 AS data cube) on the SharePoint 2007 server. I can publish a pivot table, but ...
2204 byte By
PriyaG at 2008-2-4
HelloI have been trying to use managed UDF for the Client (as Add-In) and Server excel workbook on sharepoint server.I have followed the site http://msdn2.microsoft.com/en-us/library/bb267252.aspx which explains "Extending the Excel Services Programmability Framework".1. Created a UDF ...
164 byte By
dcpt at 2008-2-3
The MOSS 2007 Excel services' report only display ~70 rows at a time. Is there any way to display all rows at once (about 120 rows)? Regards,
1833 byte By
Marin at 2008-2-3
We are deploying SQL Server 2005 with Analysis and Reporting services. This deployment is still in test/development phase. At this point I am stumbled at publishing an Excel 2007 pivot table (linked to the SQL 2007 AS data cube) on the SharePoint 2007 server. I can publish a pivot table, but ...
2064 byte By
PriyaG at 2008-2-2
HelloI have been trying to use managed UDF for the Client (as Add-In) and Server excel workbook on sharepoint server.I have followed the site http://msdn2.microsoft.com/en-us/library/bb267252.aspx which explains "Extending the Excel Services Programmability Framework".1. Created a ...