Refresh Excel Data using Excel App in Sharepoint with an existing Sharepoint list

Hi,

I am new to sharepoint and have an excel document with Pivot tables stored on SP2013. Its report I want to be refreshed with data from a SP list on the same site?   Site is SP2013, with Excel App available to user.

Is it possible to make a data connection string to the sharepoint list and have the Excel Doc "Refresh All" button refresh the data table and refresh the pivots for users viewing the excel document?

Can this be set up using Excel in office 365 then placed at the SP site and then from the SP site, the odbc connection function?

Thank you

DavidR

June 19th, 2015 1:45pm

Hi David- see the following link for requirements, including both manual and auto refresh:

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

Free Windows Admin Tool Kit Click here and download it now
June 19th, 2015 6:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics