SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an excel file set up to pull data from SQL Server 2008R2. I can view it and refresh it fine locally in Excel 2010.

I upload it to SharePoint 2010 and can view the data in the spreadsheet in the browser using Excel Services. However, when I click to refresh the data in the spreadsheet in the browser (clicking Data > Refresh All), the data does not get refreshed. One thing to note is that when I do open up the excel spreadsheet in the browser it shows this message:

enter image description here

share|improve this question

migrated from Apr 25 '12 at 16:18

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

I had configured to pull SQL data through a "Table" view. It needed to be set up to use a "Pivot Table" view.

share|improve this answer
please describe more about how this is configured by you... add a link or link to your blog ... – saber tabatabaee yazdi Jan 22 '14 at 13:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.