| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel limit that stops pivot table processing at column IV??
I have an Office-X compatible spreadsheet on a PC and Mac that has been
working fine. It is an automated Macro w/ Visual Basic. A larger than previously experienced data file (CSV) arrived and the Pivot Table consistently quits at column IV. Internal size limitations? Doesn't seem like Visual Basic word size problem. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel limit that stops pivot table processing at column IV??
All current XL sheets are limited to 256 columns (column IV)
In article , TooTall wrote: I have an Office-X compatible spreadsheet on a PC and Mac that has been working fine. It is an automated Macro w/ Visual Basic. A larger than previously experienced data file (CSV) arrived and the Pivot Table consistently quits at column IV. Internal size limitations? Doesn't seem like Visual Basic word size problem. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel limit that stops pivot table processing at column IV??
Never ran into it. Is it safe to assume that Visual Basic, etc, does not
have this limitation? Thank you for your quick response "JE McGimpsey" wrote: All current XL sheets are limited to 256 columns (column IV) In article , TooTall wrote: I have an Office-X compatible spreadsheet on a PC and Mac that has been working fine. It is an automated Macro w/ Visual Basic. A larger than previously experienced data file (CSV) arrived and the Pivot Table consistently quits at column IV. Internal size limitations? Doesn't seem like Visual Basic word size problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| organising dates in pivot table column | Excel Discussion (Misc queries) | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
| Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
