Excel Size limits
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Excel Size limits

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    T Cox
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I was first wondering what is the maximum size for an excel file/spreadsheet. Also at work someone with a file that is about 5megs or so is loosing from time to time comments. Sometimes they loose the whole comment and not the comment mark and other times they do. I hope hou can give us some insight to this problem. Have a great day

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Excel limits are as follows:

    1.Maximum number of open documents is limited by available memory and system resources
    2.Maximum sheet size is 16,384 rows by 256 columns for a total of 4,194,304 cells per sheet.
    3.Maximum number of sheets in a single workbook is 255
    4.Total number of possible cells is 1,069,547,520 if your computer has enough memory in it.
    5.Column width is 0 to 255 characters. Row height is 0 to 409 points
    6.Maximum length of cell contents (text) is 255 characters
    7.Maximum length of formula contents is 1024 characters
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    117
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not sure of what you mean by size of a spread sheet (In cells its 65,536 rows, 256 columns or each sheet has 16,777,217 cells)
    It would take you 194 days to fill a number or letter in each cell at a rate of 1 cell per secound to fill one sheet! If you printed it all out it would requir aprox. 36,000 sheets of paper! And you can have as many sheets as you want! Of course your system resources would run out probley before you did that depending on your P.C.

    As far as you friends problem having a 5 meg project is common- When you say you lose the comments , Im assuming that you mean when the program is opened? Is it always the same comments that are erased or is it diffrent comments each time?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi

    Ermm i like this and offer some under cover tips that could help just a way or working, im extreamly lazy and work smart not hard of cause, how else can i play with Excel...

    OK 5 MB is fine she will be fine on any PC you can run windows BAR server editions and any XP related software. WinY2K will run if like a drung dog.

    Now over save 7-8mg shes carrying a bag to much shopping so you need to tak care of you or no dinner tonight... (excel a she as i love her and shes my best friend) now i have sheets that are 27mb and 35mb is slow heavy and not recomended.

    But this is my tip:

    any formula i write i write it down REGARDLESS, i know sad and boring but true and index card them i also have a sheet that called Jack FOrmula and VBA i know even sadder, but also i have section in that sheet wehere i have cells with my comments in so what i do id the A5 will read H34 comment, cell B5 will read Jacks comment This cell is directe dfor .. bla bla blar!

    The comment i imput via VBA ok i have clouds that are a light blue colour and whit fulffy cloud on it also and link the cell data in B5 to this comment. BINGO all there to read but, who cares if lost just click and its back........ i BACK up copy sheets to Network and also the entire book regula so i dont care if i loose the lot...


    just some ideas, let me know if you need more details on a part ill tell more if your intrested.

    yes i used to have the teletubbies as a comment once! dam i must get out more.
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    New Member
    Join Date
    Jul 2003
    Location
    Dallas
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Size limits

      
    You had indicated in an earlier e-mail that the maximum characters per cell is 255 - Anyway to expand the capacity? I can enter data beyond 255 characters; however, anything beyond 255 will not print when I print the spreadsheet. Thank you!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com