1
3
Every time I create a pivot table (available for all Excel versions) I get one or several blank fields. How can I get rid of them?
One workaround I used was to select the blank field, right click | Filter | Hide Selected Items. This can solve my problem but I need to do it manually... Is there a way to automatically hide/exclude the blanks?
Right, but there are some fields that need to be blank (or just there is no value for these fields). I need to find a way to automatically exclude the blanks (data range is already set, only new data is added and then the pivot table is refreshed) – Nicu Zecheru – 2009-08-18T16:37:52.800