ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding columns to an Excel matrix and listing them in the PT (https://www.excelbanter.com/excel-worksheet-functions/162317-adding-columns-excel-matrix-listing-them-pt.html)

Jellis65

Adding columns to an Excel matrix and listing them in the PT
 
I have an Excel matrix that I need to add additional columns to. When I add
the columns they do not show up in the Pivot Table List of items to be added
to a pivot table or report. How do I make them visible in the PT list?

Sasa Stankovic

Adding columns to an Excel matrix and listing them in the PT
 
hy,
pivot table is not always conected to your table. it uses thing called pivot
cache to create pivot table report.
so, you'll need to refresh your pivot if you made any changes to source
table.

"Jellis65" wrote in message
...
I have an Excel matrix that I need to add additional columns to. When I
add
the columns they do not show up in the Pivot Table List of items to be
added
to a pivot table or report. How do I make them visible in the PT list?





All times are GMT +1. The time now is 01:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com