I am trying to create a pivot table from a range.

The range has 29 columns, The pivot table insert will create a table, but will only show the first 23 columns.

Column 24 thru 29 contains formulas. but they will not show in the pivot table.

Columns 24 is an active status- and is either a 1 or 0, this can change at any time.

I had planed to use the active status as a filter to only show data for active employees.

But can not get that column to show.

Is there a limit on the number of columns in a pivot table?

Thank You
Jesse