#1   Report Post  
Posted to microsoft.public.excel.misc
Ron Ron is offline
external usenet poster
 
Posts: 250
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? Rob Gordon Excel Discussion (Misc queries) 1 December 2nd 08 09:34 PM
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 Stuart[_4_] Excel Discussion (Misc queries) 2 October 6th 08 05:07 PM
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? lewisma9 Excel Discussion (Misc queries) 0 February 27th 07 12:23 AM
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message [email protected] Excel Discussion (Misc queries) 0 July 10th 06 03:07 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 12:07 AM


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"