Automatically Refresh Pivot Table w/o Opening Excel [SOLVED]

[hollynordenberg]

Hi -

I have read many ways to have Excel update all pivot tables automatically upon opening the workbook, but I want the pivot tables to update daily without opening the workbook.


For reference, I have the pivot tables displayed in a SharePoint Excel Viewer WebPart, and I want the pivot tables to update daily without having to open the file so the updated pivot tables show up in my SharePoint web part.


Any help is appreciated. Thanks!

 

[bobhc]

Good day hollynordenberg


Perhaps this link will help


http://sharepointside.blogspot.in/2011/12/refresh-pivot-table-or-chart-with-excel.html

 

[hollynordenberg]

Bobhc - I believe this is going to work for me. Thank you very much!!

 

[bobhc]

Good day hollynordenberg


Pleased it will do as you require...Thanks for let the forum know