• Excel Workbook Capacity

    Author
    Topic
    #351970

    Hi – I thought I’d try one more time, just in case – and . . . since I got the version wrong last time. Does anyone know the capacity in bytes of an Excel workbook V98 for Mac? I have a user who wants to know because of a large file he has created (and continues to add to)! Thanks

    Viewing 0 reply threads
    Author
    Replies
    • #510740

      I don’t run the MAC version, but copied below is the HELP entry from Excel 8.0 (Office97). While there are limits imposed by available memory, I’ve never seen any ‘byte limit’ to workbook size. I’ve seen posts over the years from people claiming to have workbooks into the 32Meg range.

      Program workspace specifications

      Feature Specification
      Maximum number of custom toolbars in a workbook Limited by available memory
      Maximum number of custom toolbar buttons Limited by available memory
      Maximum number of open workbooks Limited by available memory and system resources
      Maximum worksheet size 65,536 rows by 256 columns
      Column width 0 (zero) to 255 characters
      Row height 0 to 409 points
      Maximum length of cell contents (text) 32,000 characters
      Maximum length of formula contents 1,024 characters
      Maximum number of sheets in a workbook Limited by available memory (default number of sheets is 3; the maximum number of sheets in a default workbook is 255)

      • #510743

        Wheee! Thank you so much – He’s happy and now so am I.
        Thank you – Thank you . . .

    Viewing 0 reply threads
    Reply To: Excel Workbook Capacity

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: