JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- 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
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