.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

Editing cells in Excel web acces web part

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
Hi, I am using the excel web access web part that displays an excel spreadsheet in my web page. In order to edit the cells I need to name each cell,add the name in the parameters section in the Publish options and then publish it to Excel Services. I was wondering if there is a way to edit the spreadsheet of the web access web part similar to a normal excel spreadsheet? Thanks

View Complete Post

More Related Resource Links

Enhance SSAS so that a calculation returns multiple cells at once (Excel fill not a single cell but

I wonder if somebody can help me with the following question. I would like to create an enhancement to SSAS in a way so that one can pass in multiple values, run a calculation and in return retrieves not one but multiple cell results at the same time e.g. retSet = functionABC(inSET) where inSet is somthing like 5 4 3 6 7 3 4 4 AND retSet is 4 6 7 8 9 3 4 4 All my calculated members in MDX return a single value BUT I need to have a calculation that if called returns multiple results (a set) at once and in a way so that Excel will properly pick up on it and consequently fills multiple cells in the Pivot table. Is that possible at all and if so how? I would not mind to write a little CLR assembly to enhance the SSAS but don't know how to pass the results back. Any ideas are highly appreciated. Dirk

Excel Web Part - different Powerpivot Slicer disabled tue to sharepoint users

Hello, first of all i'm new to sharepoint. I found quite similar question to mine http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/9f23a77c-1527-48a8-abbc-2ccded736d9e but unfortunately it hasn't been answered. So what i have done so far: I made a Excel 2010 Powerpivot chart and Published it to sharepoint via the Powerpivot gallery. I also created a Excel web part with the spreadsheed in it. I am searching for a vba script to achieve the sharepoint username but found only some for the windows username. I also managed to disable slicers in vba. What i want to achieve: Due to the fact that the Powerpivot chart has some critical security data in it the different users should only see two different filter options (whole data and one slice for themself) So i need to disable slicers in the pivot chart tue to the sharepoint accounts. My Qestion: Is it possible? If yes, how! Any help would be appreciated. Is it possible via VBA or do i have to use Excel web scervices?  Thanks for your help :)

Target audiences not working in excel services web part

My appologies i posted this originally in the pre-2010 forum So i'm reposting here: We have recently upgraded to Sharepoint 2010 and we're experiencing problems with the "target audience" field being available to the users. I am not the CA admin though so it'll make this a bit tough to get solved if the problem is there. What i'm looking for are the suggestions of things for me to forward to the CA admin to change or check if anything. We have a seperate Virtual Machine that is running 2010 that has this option available to users on that farm for some reason. however on our corporate farm we don't have that option available. Plus on top of this the quick launch items are not working with audiences as well to turn off the headers to links that have nothing in them due to security trimming on document libraries. I'm hoping that this being a more of an overview of things to check would help others who may have this problem as well. I've seen resolutions such as rebooting the server and such, however that's a bit lower level and we need some higher level things to check that may resolve the issue. Think the simple stuff first to check and lets work down the list. Doesn't matter how stupid it is but can we get a more compiled list of things to check to make sure that target audience visibility to users is enabled? Thanks!

Anonymous access on Excel Viewer web part for a no access .xslx file?

I have a public facing SharePoint 2010 Enterprise website with anonymous access enabled. I'd like to present information (a pivot chart) from an .xslx file using the Excel Viewer Web Part. It works fine when I place the .xslx file in a document library that the anonymous users can access. I would, however, like to remove anonymous access from the .xslx file and only expose the chart from the .xslx file using the Excel Viewer web part. When I alter the library permissions to remove anonymous access to the library that holds the .xslx file, the Excel Viewer web part displays an "Access Denied" message to the anonymous user. Is there some other way to achieve this?

Choice Filter Web part and Excel Web Access web part

I have a choice filter web part where in I have months like Jan,Feb,Mar etc and a excel web access web part. The choices in the filter web part should determine the URL of the workbook for the excel web access web part. In the filter web part I gave the choices as Jan;http://sitename:port/ExcelList/MyExcel.xlsx where "ExcelList" is the library that stores the excel files for each of the months. But the excel web part always says that "The file selected couldnt not be found". Is it possible for me to know the actual URL getting passed to the excel web access web part? Pl suggest if there is a better way to do this. Cutloo

about using excel sheet to acces a cube?

how to access an ssas cube using excel? any information about pivot table in excel, please provide

Excel 2007 Cubeset function needs to pull list based on part of field value (ie contains, wildcardin


I have a Cube with a field called 'Item Code'.  This field is six characters in length.  The first two characters differentiate what kind of product it is.  I am building my reports with cube functions.  I do not want to use a pivot table to retrieve the list by using the 'contains' or 'begins with' label filters.  Is there a way to use the cubeset function with left, mid, right functions?  I realize that it can be set up in the cube as a separate field, but I am not able to update the cube.  Below are my examples - 'All Products' and 'Product R3189S' work fine, but I need to retrieve 'Products starting with R3'.

=CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].children", "All Products")

=CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].[R3189S]", "Product R3189S")

= CUBESET("Financials Sales Cube", "[Product Dimension].[Item Code].[All Product Dimension].[R3****]", "Products Starting with R3")

Thank you in advance.


Excel Web Part not refreshing


Environment: MOSS 2007, SQL Analysis Server 2008

I have a Web Part that displays a Pivot Table from a Trusted Excel doc. When I open the Dashboard page with this web part, I see correct data. When ANOTHER user does the same, (this user does NOT have ANY permissions to view or browse the base cube) they see the LAST CACHED VERSION of this Excel Pivot Table from when it was last saved. This happens even if I set the "Refresh Data on opening of file". And I have also see in a SQL Trace that the account that hits the cube is the SharePoint Service account, NOT the user in question. Should I be concerned?

How do I make it so that if a User does NOT have permissions on the cube, that Excel Services won't show them any data?

Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Protect part of Excel sheet via Excel Services


Is it possible with Excel Services or other Out Of the Box standard features, to create a functionality as below description.

"Make an Excel sheet frozen/not editable on existing row but at the same time let users be able to create new rows, populated with a running numberid preferable in Sharepoint somehow?" 

//Best regards

How to lock the cells in Excel sheet using asp.net



i am using gridview control to export data from database to excel sheet but i am not protect(lock) the cells . pls give solutions "How to protect(lock) the cells in Excel ? " pls . I  am using Asp.net 2010 Express . Please Help me .




Dropping and linking multiple items within the same editing scope transaction - Part 2



In an earlier forum post, I asked about how to drop multiple items from the toolbox onto the design surface, have them arranged nicely, and do all this in a single editing transaction.  In that post, Kenny came up with a nice solution.

There's one more scenario that I didn't discuss in the earlier post, that I was hoping to be able to resolve on my own after getting the other post answered.  But, I I'm afraid I need some more help.

The scenario is the same as in the earlier post with one additional complication.  One of the items I'm dropping as part of the drag/drop operation is a FlowSwitch node.  If I did nothing else, the solution presented in the earlier forum post would work.  However, I've an additional need to visually change the appearance of the FlowSwitch designer. Normally, one can change an activity's designer (even a built in activity) by using the metadata store.  However, the FlowSwitch is unique in that the Flowchart designer has hard-coded knowledge of the FlowSwitch designer, and if you replace the built in designer via the metadata store, there are numerous places where the Flowchart designer will generate exceptions and pop up error messages.  I also have the need t

Exporting to Microsoft Excel from a DataView Web Part consuming a Web Service with Parameters

In Sharepoint Designer, I've developed a page displaying a DataView Web Part which consumes an XML Web Service with three parameters.  These parameters are passed in from a simple Form Web Part containing three input fields.  I am able to provide default values for the web service so the dataview is initially populated, and when I enter in new parameters, the web service goes back, grabs the requested data and displays in the dataview nice and slick.

The problem I'm having is this: In Internet Explorer 7, when I right-click on the DataView Web Part and select Export to Microsoft Excel, Excel opens up, says "ExternalData_1: Getting Data..." and returns the data from the web service which applies to the default parameter values each and every time, regardless of whether I have changed the parameters on the web page, and contrary to what the DataView Web Part displays on the screen.

Has anyone else run into this, and is there a solution to the problem?

Best regards,
Mark Christie

Excel as a web part


Hi All

I am currently using Sharepoint Foundation and i am looking to create a dashboard on my sharepoint site that will show real time information from an excel spreadsheet, I would like to add the spreadsheet or part of it as a web part, However i know that sharepoint foundation is limited, I know Sharepoint Server Enterprise has something called Excel Services but like i mentioned we are using the Foundation Version.

Is there an alternative way of doing this.


Editing the list and view of a content query web part


I have added a content query to my site which is querying a master contact list.

Once I have added the web part I then want to customised how it is displayed, i.e. first name, company name etc.

I am not getting a list menu in the ribbon when I check the box next to my content query web part heading.

Can anyone help.

Excel services wont display in web part, fails with a Event ID 5239

After upgrade to SP2 and current Cum SP, no sites in my portal taking advantage of Excel services can function.

checked event log and found the following

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Excel Services Web Front End 
Event ID: 5239
Date: 10/15/2010
Time: 1:50:52 PM
User: N/A
There was an error in communicating with Excel Calculation Services http://BLAHBLAHBLAH:56737/SharedServices1/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 403: Forbidden.
[Session: (null)
User: SHAREPOINT\system].

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Any help is greatly appreciated, thanks.

Contacts web part from Excel. Content Editor web part from Word.


I use the Contacts web part and the Content Editor web part a bit. I was wondering if I could populate the Contacts web part from a Excel spread sheet which has been uploaded to the document library. This was I only have to modify the spreadsheet and all the changes will be published to the Contacts web part.

Similarly, can the same be done for a Content Editor web part such that the content comes from a document in the document library.

Please advice.

Creating a drop down menu with a variable range of cells in excel using Visual Basic


I can create a drop down menu using a range of cells as follows:

    With Selection.Validation
        .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:="=$G$2:$G$10"
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True
    End With

I would like to create the drop down with a range of cells using variables.  For instance, in the line which contains $G$2:$G$10, I would like to substitute something like range(cells(1,2),cells(x,2)) to allow me to change the length of the menu depending on how much data has been entered.  Does anyone know how I can do this?


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