Excel 2003

R

Ron

I have a large workbook that track data weekly in columns. I have run out of
columns ending at "IV". I know excel has more columns than that. How do I fix
the issue?

Thanks
 
P

Pecoflyer

Ron;221174 said:
I have a large workbook that track data weekly in columns. I have run
out of
columns ending at "IV". I know excel has more columns than that. How do
I fix
the issue?

Thanks
Click to expand...

Yes XL has more columns, but only in XL2007.
You might want to revise your data layout or convert to Access


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster
 
S

Shane Devenshire

Hi,

Excel 2003 does not have more than 256 (IV) columns. And there is nothing
in 2003 you can do to "fix" this problem. Upgrade to 2007 you will have
16,384 columns.
 
S

Shane Devenshire

Hi Pecoflyer,

Access 2003 only supports 256 fields (columns) per table.
 
Top