Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Location
    Poland
    Posts
    18

    Unanswered: rows limit in spreedsheet

    hello everybody

    does anyone know the way to overcome the limit of 65536 rows in excel spreedsheet.maybe programically is that possible??
    thanks in advance for every help

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    No, not possible.

    What are you trying to do that you need to exceed 65,536 rows?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Location
    Poland
    Posts
    18
    Originally posted by shades
    No, not possible.

    What are you trying to do that you need to exceed 65,536 rows?
    thank you for a good approach to the question.the answer is:
    I need it for nothing,but the problem is of the different kind.
    My job in the the firm where i work in, is to write procedure and macros for the controlling departments in VBA (not only).Despite of many examples of how vba have helped them in their work i still hear voices like this "excel is good but it has the limitation.you cannot exceed the number of rows over 60....rows". i heard that so many time that i had to check this out.
    im sorry for engaging your time and thank you for the answer

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Not a problem. A little trivia for them if they want to see how much each worksheet in Excel holds. Have them put a number into one cell, then another number into the next cell. Then do it for the entire worksheet (16,777,216 cells). And fill in a cell at the rate of one cell per second, continuous, no breaks. It will take the person 194 days, and to print just that one worksheet it would take 6 ft of paper.

    And the number of worksheets available in a workbook is limited only by the memory of your PC.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Oct 2003
    Location
    Poland
    Posts
    18
    thank you shades for a good proposal

    i was really laughing having been reading your post but...
    seriously your hints were a very instructive lessons for me.
    bye the way. with regard to the people from my company i thought to myself that they deserved to see only nothing.let them lead a live of ignorance

    see ya

Posting Permissions

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