1
vote
0answers
66 views

Use an Access Web Database as a data source for Excel?

I have an Access 2010 Web Database published to SharePoint as described here: http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx If my Access ...
0
votes
1answer
48 views

How to refer to a local file for a PowerPivot datasource?

We have users trying to use Performance Point and need to point to a local PowerPivot file as a data source. The instructions state: Type the connection string to the PowerPivot data source by ...
2
votes
0answers
185 views

offline and online (SP 2010) version of Excel with slicer

An user uploaded Excel with Pivot that has slicer to sharepoint document library. The data for this excel coming from SQL backend. The browser gives following error. "The workbook cannot be opened ...
0
votes
0answers
122 views

PowerPivot with MySQL connector

I have a powerpivot document using a MySQL connector and when added to SharePoint it doesn't seem to think it has a dataconnection. Is there anyway to get this type of powerpivot document to work ...
0
votes
0answers
55 views

Is it possible to sort by month name in PowerView?

Is it and if how possible to sort by month name without having to add a number in front in Powerview? I would like to change these month id's to month literals so 1 > JAN: Screenshot 1
1
vote
2answers
2k views

Unable to Refresh the Excel Connection in Excel Webaccess Webpart

I am using an excel workbook with pivot in it. I am using the Excess webpart to display it. As I click on the Refresh all data connection. It throws an error.The scree shot is attached. I have ...