Floating Slicers

[rousseauassociates]

I have a pivot table that is driven by slicer.

The number of columns in the PT means the user has to use the horizontal scroll bar to see all of them with column A and the header row fixed via the freeze panes.

What I want to do is have the slicers boxes (5 of them) to move with the horizontal scrolling of the screen if possible.


Thanks

[Olly]

What you're trying to achieve involves detecting scrolling of the workbook, then repositioning the slicers accordingly. Not easy.

See http://www.cpearson.com/excel/DetectScroll.htm for more information about detecting scrolling.

It would be easier to insert a column to the left of your pivot table, and have your slicers placed in that (frozen) column.

[rousseauassociates]

Thanks Olly

I did see the CPearson page and it looks like a lot of work and it's a requirement more from being fussy rather than a necessity.

I don;t quite understand how you frozen pane with a blank column would work as placing anything in this column would effectively scroll off the screen as I scroll right wouldn't it?

[Olly]

I don;t quite understand how you frozen pane with a blank column would work as placing anything in this column would effectively scroll off the screen as I scroll right wouldn't it?

Try it. Select range B1, then choose "Freeze Panes". Now try scrolling to the right - you should see Column A stays visible, yes?

Look at the attached workbook for a worked example.

[rousseauassociates]

I see what you are getting at but unfortunately the number of slicers and the number of options in them means that there just isn't enough space in the height of a screen to put them all.

It's certainly something I could use when using smaller datasets but for this dataset it doesn't work.


Thanks