Excel 2003
 

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
--
Ron

Excel 2003
 

Ron;221174 Wrote:
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
--
Ron

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
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60940

Excel 2003
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Ron" wrote:

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
--
Ron

Excel 2003
 

Hi Pecoflyer,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Pecoflyer" wrote:


Ron;221174 Wrote:
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
--
Ron

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
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60940