View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default need help with pivot charts

Hi Joe

XL2003 and lower only have 256 columns, the last being IV.
XL2007 has 16000 columns, but if you have loaded a file created in
XL2003, it will have loaded in compatibility mode, and will only go to
column 256.
Save the file as an XL2007 file (.xlsx), close it and re-open and you
should be able to access columns beyond IV.

--
Regards

Roger Govier


"joe hunter" <joe wrote in message
...
When working with a pivot chart at work i can access(view) all of the
data
in columns
out to column IV. How can I view columns past this point????