| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Pivot Table Changes the Source Data Range
I have several Excel 2007 files with Pivot tables in the files. When the
files were created the source range for the data was (nameofsheet $A:$J) and now all the files have changed the data source in the Pivot Tables to the following: (name of sheet $a:1:$J$16384) As it turns out 16384 is the maximum number of columns allowed in a pivot table, but, Im not sure why all my files are changing to that. Has anyone come across this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| source data for pivot table 2007 | Excel Discussion (Misc queries) | |||
| 2007 Table Linked Charts - Limit Data Source Range? | Charts and Charting in Excel | |||
| View pivot table external data source in Excel 2007 | Excel Discussion (Misc queries) | |||
| Using cursor keys to select Pivot Table Source Data Range | Excel Discussion (Misc queries) | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
