Results 1 to 4 of 4

Thread: Excel 2003

  1. Jun 6th, 2010, 01:49 PM #1
    Honsolo
    Honsolo is offline

    Thread Starter
    Lively Member
    Join Date
    May 2010
    Posts
    80

    Excel 2003

    I have reached column "IV" not sure the number of columns but in reading I know the max column is 65536 in Excel 2003. For some reason I can't insert any more and i know I am well below that number. I'm wondering if that number is actual columns or max something else.
    Reply With Quote Reply With Quote
  2. Jun 7th, 2010, 02:54 AM #2
    Siddharth Rout
    Siddharth Rout is offline
    Discovering Life Siddharth Rout's Avatar
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    12,001

    Re: Excel 2003

    Quote Originally Posted by Honsolo View Post
    I have reached column "IV" not sure the number of columns but in reading I know the max column is 65536 in Excel 2003. For some reason I can't insert any more and i know I am well below that number. I'm wondering if that number is actual columns or max something else.
    No, you are mistaken (or probably it is a typo?). There are 256 Columns ('IV' being the last) and 65536 Rows in Excel 2003.

    How are you inserting rows/columns in Excel?

    Also could you clarify how is Crystal Reports, Access and Data Report Designer involved in this entire stuff?
    A good exercise for the Heart is to bend down and help another up...
    Please Mark your Thread "Resolved", if the query is solved

    MyGear:
    ★ CPU ★ Ryzen 5 5800X
    ★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
    ★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
    ★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
    ★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
    ★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
    ★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
    ★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
    ★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
    ★ Keyboard ★ TVS Electronics Gold Keyboard
    ★ Mouse ★ Logitech G502 Hero
    Reply With Quote Reply With Quote
  3. Jun 7th, 2010, 03:36 AM #3
    Pradeep1210
    Pradeep1210 is offline
    VB Addict Pradeep1210's Avatar
    Join Date
    Apr 2004
    Location
    Inside the CPU...
    Posts
    6,614

    Re: Excel 2003

    Also it seems like it is not even a question worth asking. You can know yourself by just opening Excel and checking the last row/column.

    Name: excel-max-row-and-column.JPG Views: 101 Size: 67.6 KB
    Pradeep, Microsoft MVP (Visual Basic)
    Please appreciate posts that have helped you by clicking icon on the left of the post.
    "A problem well stated is a problem half solved." — Charles F. Kettering

    Read articles on My Blog • 101 LINQ Samples • JSON Validator • XML Schema Validator • "How Do I" videos on MSDN • VB.NET and C# Comparison • Good Coding Practices • VBForums Reputation Saver • String Enum • Super Simple Tetris Game


    (2010-2013)
    NB: I do not answer coding questions via PM. If you want my help, then make a post and PM me it's link. If I can help, trust me I will...
    Reply With Quote Reply With Quote
  4. Jun 7th, 2010, 05:46 AM #4
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Excel 2003

    Moved To Office Development
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width