itaysk

We were told that Excel Services has support for displaying data from external locations, such as SQL

I was trying to key of a SP KPI Indicator based on data in a Excel Spreadsheet that has External Data Connections and it failed. Maybe making it a pivot table might work but what are my other options here. Any ideas?

Thanks for this information!  Quick question, how do you convert that pivot-table back to a regular table?  Is this done in Excel or from the webpart properties?

Great info, resolved some of my frustrations using Excel Web Access.  Thanks.  It is working in SP now but I get an error when refreshing all connections:

Unable to retrieve external data for the following connections:

The data sources may be unreachable, may not be responding, or may have denied you access.

Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set.

The refresh works when I edit the workbook, am I screwed?

Thanks

Norm

BEHIND THE JACKPOT; Divide And Conquer: <a href="http://mvltns.webs.com">Movie composition Titans</a>

Thanks for ur information.............. I hav been trin out external connection for more than a week....... but no idea about pivot table.... Anyway let me check it out.......

Hi,

I want populate the data from different table to my excel shhet & also want to publish it using  excel service in sharepoint.

 Please help me if anybody has any idea...

Thanks in advance.

Sarmila

Pingback from  Unable to Load Workbook &#8211; MOSS 2007 &laquo; SharePoint Expert&#8217;s Blog for Noobs

thanks Itay Shakury........

hi itaysk,

can you please explain how can i convert tbale to PIvot table,Its not clear from the blogs you have provided