No, the pivot table won't let you do that. You can hide the drop down arrow for that pivot field but that doesn't stop anyone from seeing other dept's data by adding/moving the field elsewhere, or adding a slicer.
The only way to retain pivot table functionality is to include only the data for that dept in the file you send.
This was discussed in yet another thread of yours here:
http://www.vbaexpress.com/forum/show...l=1#post408588
where in the same thread in msg#15 I showed you how to include only a subset of the data pertaining to only one dept in the files you send out. That will allow your pivot table to operate fully, but there'll only be one dept in the dropdown because other dept's data simply isn't there in the file.
Originally Posted by p45cal
Posting Permissions
Reply With Quote