• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter Pivot Table

C

Capo Mele

New Member
Hello,


I've got a Pivot Table and I use some VB to filter the data. This works fine as long as the filtered data exists. But when there is no data that meets the filter something strange happens. The Pivot Table returns data although there is nothing to show. Has anybody got an solution for this?
 
Hi Capo Mele


check if you have VB filter range set for the whole table - otherwise please send here the file to test it.

Good luck


slaya_cz
 
Hi Slaya_cz,


You can download the file from here: http://stratus.onderzoek.nl/voorbeeld/chandoo_pivot.xls


Regards,


Johan
 
You must log in or register to reply here.
Back
Top