| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column limit for Pivot Table data source
Is there a limit for the number of columns in a data source for a pivot table
in Excel 2007? My data source is a table object with 80 columns. I can create a pivot table for the data, but upon trying to refresh it tell me there is too much data. If I reduce the columns by exactly 1, it works fine...limit of 79...very odd number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Table Linked Charts - Limit Data Source Range? | Charts and Charting in Excel | |||
| Pivot table source data | Excel Discussion (Misc queries) | |||
| Excel limit that stops pivot table processing at column IV?? | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
| Pivot Table Source Data | New Users to Excel | |||
Threaded Mode
