Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |