Prinz Jaymes
Member
Hi Ninjas,
I routinely export data from SqL into Excel using PowerPivot.
The Powerpivot report (template) already contains several Slicers , but just like all Pivot tables, you need to manually REFRESH (or Refresh All) whenever the data from SQL changes and the report is ran.
Is there a macro that can help to automatically refresh the PowerPivot report (like a button) - Please note, the issue here is for Slicers to be updated automatically with any changes in data from SQL?
or
In the attached file, there is a code that automates the pivot table. This is because the data is coming directly from a worksheet in Excel, and not in SQL, like my issue above.
Is there a way to tweak the code if the "data table" came directly from SQL?
I routinely export data from SqL into Excel using PowerPivot.
The Powerpivot report (template) already contains several Slicers , but just like all Pivot tables, you need to manually REFRESH (or Refresh All) whenever the data from SQL changes and the report is ran.
Is there a macro that can help to automatically refresh the PowerPivot report (like a button) - Please note, the issue here is for Slicers to be updated automatically with any changes in data from SQL?
or
In the attached file, there is a code that automates the pivot table. This is because the data is coming directly from a worksheet in Excel, and not in SQL, like my issue above.
Is there a way to tweak the code if the "data table" came directly from SQL?
