Hamond
06-23-2008, 03:58 AM
Hi,
I'm accessing an external text file using a pivot table from excel but the number of columns is exceeding the 256 Column Limit in excel. Like many, I don't have the latest version.
Does anyone know a way to show more than 256 columns for example, showing pivot table or even a static copy of results of the pivot table in multiple sheets?
I've seen macros that let you import more than 65K row limit but importing the data across multiple sheets, was just wondering if there is anything similar for columns and results from a pivot table.
The columns/Fields in the source file are:
1) Date
2) Code
3) Price
4) Volume
5) Discount
And my pivot table is arranged as Row: Date, Column: Code, Main Body:Price. So my codes exceed 256, there are around 650 codes. Once I have the data in this format, I don't need to modify it anymore so I was thinking if there was a way to show say the first 256 codes, copy the results onto another sheet and then show then next 256 etc.
Hope someone can provide some advice.
Thanks
Hamond
I'm accessing an external text file using a pivot table from excel but the number of columns is exceeding the 256 Column Limit in excel. Like many, I don't have the latest version.
Does anyone know a way to show more than 256 columns for example, showing pivot table or even a static copy of results of the pivot table in multiple sheets?
I've seen macros that let you import more than 65K row limit but importing the data across multiple sheets, was just wondering if there is anything similar for columns and results from a pivot table.
The columns/Fields in the source file are:
1) Date
2) Code
3) Price
4) Volume
5) Discount
And my pivot table is arranged as Row: Date, Column: Code, Main Body:Price. So my codes exceed 256, there are around 650 codes. Once I have the data in this format, I don't need to modify it anymore so I was thinking if there was a way to show say the first 256 codes, copy the results onto another sheet and then show then next 256 etc.
Hope someone can provide some advice.
Thanks
Hamond