Hi Good day
I have an excel with a sheet that there is more than 40 pivot tables, some of which need to be updated by changing daily dates,
I manually in Daily Date Slicer, choose the new day to update the Pivot Tables, but it is very time consuming, it may be a macro code to automatically update a few specific Pivot Tables by changing the daily date (after 12 nights).
In other words, I want to update automatically some pivot tables at 00:00 am by changing the date of the computer
Note that all Pivot Tables were created as OLAP .
Thanks.
I have an excel with a sheet that there is more than 40 pivot tables, some of which need to be updated by changing daily dates,
I manually in Daily Date Slicer, choose the new day to update the Pivot Tables, but it is very time consuming, it may be a macro code to automatically update a few specific Pivot Tables by changing the daily date (after 12 nights).
In other words, I want to update automatically some pivot tables at 00:00 am by changing the date of the computer
Note that all Pivot Tables were created as OLAP .
Thanks.
