Is this possible?
Instead of having the pivot table field box is there anyway you can have the field options as slicers instead? Purely for aesthetic reasons...
Is this possible?
Instead of having the pivot table field box is there anyway you can have the field options as slicers instead? Purely for aesthetic reasons...
Slicers require a data source and therefore you have to have a Pivot table first before you can use Slicers. Then you can copy Slicers to another spread sheet.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
your profile says 2007 so you can't have slicers at all ;-)
do you mean you want a slicer that works like the field list?
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks