Can't move Timeline slicer

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,696
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have:
A sheet with data, defined as a table
A sheet filled with pivot tables (source data above)
A sheet with pivot charts and pivot slicers

This third sheet did have a timeline slicer and I'm not sure how but resizing and moving cells around, it's disappeared (there are no hidden rows or columns or anything equivalent).
I used VBA to verify the shape count on the sheet and it did appear that there was no timeline slicer.

Back to pivot tables, insert timeline slicer, connect to other pivot tables. I then select the timeline slicer, press CTRL+X to cut it but when I switch to the third sheet and press CTRL+V, nothing pastes, but the timeline slicer no longer appears on the sheet with pivot tables.

No worksheet events, only VBA code is to add a (4th) sheet with a specific name based on today's date and this has no relation to any of the sheets described above.

Has anyone experienced this or can suggest a cure?

TIA,
Jack
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,696
Office Version
  1. 365
Platform
  1. Windows
Found a answer, on the Sheet with the pivot charts and slicers, selected a chart and then through the pivot menu added a slicer, then connected it to the required charts.

Not sure if this is expected behaviour or not being able to move between sheets, but found a solution
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,122,246
Messages
5,595,044
Members
413,963
Latest member
teggl97

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top