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