Hi,
Subject nails it really.
I have a document (i've had the same issue in lots of files) where I have numerous slicers and a timeline. When I select the timeline the slicers do not update for the chosen period unless I refresh all.
It's frustrating as it's a decent visual tool the timeline, but it's not fit for purpose while it doesn't update the slicers.
Any tips or workarounds? I've assigned a macro to the timeline forwhich doesn't work either
ActiveWorkbook.RefreshAll
Regards
Dave
Hi PFDave,
did you check the Data source of all Pivot table.
Note: if you want to refresh the data then make sure each pivot data source should be dynamically. if data source not dynamically then same data will reflect in pivot table/slicer.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi,
Only one table but I have multiple slicers and this timeline to analyse the data.
Regards
Okay , i guess u have to check Slicer Connection....
or else please upload sample workbook by removing sensitive data.
Hi Naveed, I've checked connections.
I'll mock up a version to send on here.
Thanks
Hi,
Were you able to get this issue resolved. I am looking for a resolution to the exact same issue.
Best Regards,
Satbir Minhas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
PFDave 
Register To Reply
Bookmarks