Auto refresh excel file in SharePoint library

Question

_{Friday, July 14, 2017 8:50 AM}

Hello,

I have an excel file that have data connection with one of my SharePoint list. Now I uploaded this file into library to use it on my new page as web part: 'Excel Web Access'

My question: How can I refresh all excel file (table, pivot tables and charts) without opening this file? I need this file to refresh automatically. Is it possible?

All replies (1)

_{Monday, July 17, 2017 11:45 AM ✅Answered | 2 votes}

Hi Daniel Leo,

How did you add a connection to a SharePoint 2010 list in the Excel file? Did you export the list to a Excel file and use the data connection in that file?

In SharePoint 2010, we cannot use the list as a data source for Excel Services. For more information, read the following article:

https://technet.microsoft.com/en-us/library/gg576960.aspx?f=255&MSPPError=-2147217396

By the way, there is a built-in way to refresh data in Excel.

1. Go to Data > Connections > Properties

2. Select the following option: 

Best regards,

Linda Zhang

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact [email protected]