Forum Discussion
Pivot table data source
Hello there, i'm trying to add columns to a data source for a pivot table. I cannot do that, don't know why. As you can see in the attached picture, the cell range consider (for some reason) till...
it seems to me, that not all the columns belong the the range of your source table "Table2", even if they look the same.
I prepared an example with a formatted table in columns B:D and added some additional columns outside the table with the same formatting (columns E:G).
When I place the active cell in my table and check menu "Table Design | Resize Table", it shows that just columns B:D belong to the table
You just need to select the other columns and click OK to resize the table. This way, all columns are included in "Table2" and you should have no problem with your Pivot table
Thanks for your kind help, i sorted it out 🙂