ignoring blank columns in pivot table

Sheet A in my workbook contains the 'source' data for the pivot table. I have a few blank columns in Sheet A which cannot be included in the pivot table. Is there a way around this? How can I change the source of pivot table to include all columsn except for the blank columsn?

I would really appreciate any help on this!

Thanks a ton!
Ritu

You could do this a couple of ways.

First, you could go into the pivot table wizard, and select multiple ranges, separated by a comma.

Or second, you could simply hide the blank columns in the pivot table (probably easier and preferable). Right-click on one of the pivot table columns, select Field, then you can select any columns to hide.

HTH

Jason

Thank you for your reply!

If I select multiple ranges in the source of pivot table, I get the following error "Referance is not valid".

Secondly, I already have a pivot table that is getting data from another sheet. Due to some formatting issues, I had to add a few blank columns on my worksheet. Now, If I got back to the pivot table and try to refresh data, it displays the followign messsage .."The Pivot Table field name is not valid...........". And then, if I remove the blank columns and try to refresh data on the pivot table - it works perfectly fine.

The issue is with the blank columns in the source area.

Thanks much!

I forgot to mention another step for the multiple ranges. In step 1 of the Pivot Table Wizard, you need to select "Multiple consolidation ranges". This will allow you to add different ranges one at a time. See if that works for you.

Jason

I think it works but the output is so confusing.

Is there any work around this - something easier ????

I can't believe I have to go through all of this just to remove some columsn from the Source in pivot table.

Anyway- Thank you for your help!!

You are probably getting the "pivot table field not valid" due to missing a column header. Try going into the source data, and creating headers for the blank columns (e.g. Blank1, Blank2, etc.). Then refresh from source, and see what you come up with.

YES !!! YAHOOOOOOOOOO !!

You are a genius !!

That solves the problem. Adding Blank1, Blank2, etc for the header allowed me to refresh the data successfully !!

Thank you sooooooooooooooooooooo much !!

Glad to help.