Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: excel 97 problem

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    When ever I try to open a file I get the following message..

    "No more custom formats can be added"

    The files wont open and the only way to close excel is through ctrl, alt, del.

    Any suggestions on how to fix this problem?

    Bill

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    When ever I try to open a file I get the following message..

    "No more custom formats can be added"

    The files wont open and the only way to close excel is through ctrl, alt, del.

    Any suggestions on how to fix this problem?

    Bill


    Hello Bill

    Is there any way for you to send this particular spreadsheet?(if it's not too private mate)garethl@ij.co.za

    Is it just the one spreadsheet,or a couple of them?


  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    From the help file "limitations in Excel" :

    Worksheet and workbook specifications

    Feature Specification
    Maximum number of scenarios Limited by available memory; a summary report shows only the first 251 scenarios
    Maximum number of changing cells in a scenario 32
    Maximum number of adjustable cells in Solver 200
    Maximum number of named views in a workbook Limited by available memory, although the Custom Views dialog box lists only the first 256 views
    Number precision 15 digits
    Largest allowed positive number 9.99999999999999E307
    Smallest allowed negative number -9.99999999999999E307
    Smallest allowed positive number 1E-307
    Largest allowed negative number -1E-307
    Maximum number of iterations 32,767
    Maximum size of worksheet arrays 6,553 elements
    Maximum number of colors in a workbook 56
    Maximum number of cell styles in a workbook 4,000
    Maximum number of custom number formats Limited by available memory
    Maximum number of selected ranges 2,048
    Maximum number of names in a workbook Limited by available memory
    Maximum number of arguments in a function 30
    Maximum number of nested levels of functions 7
    Number of available worksheet functions 329
    Maximum number of custom functions Limited by available memory
    Maximum number of windows in a workbook Limited only by system resources
    Maximum number of panes in a window 4
    Maximum number of linked sheets Limited by available memory
    Zoom range 10 percent to 400 percent
    Maximum number of reports Limited by available memory
    Maximum number of sort references 3 in a single sort; unlimited when using sequential sorts
    Maximum number of undo levels 16 (default)
    Maximum number of fields in a data form 32
    Earliest date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date system is used)
    Latest date allowed for calculation December 31, 9999
    Maximum number of PivotTables on a sheet Limited by available memory
    Maximum number of items in a PivotTable 8,000
    Maximum number of pages in a PivotTable 8,000
    Maximum number of row or column fields in a PivotTable Limited by available memory
    Maximum number of page fields in a PivotTable 256 (May be limited by available memory)
    Maximum number of data fields in a PivotTable 256
    Maximum number of calculated item formulas in a PivotTable Limited by available memory

    so it looks like you need to augment your memory capacity...

    actually, if you do a search on this forum, maybe with the keyword "memory", you should get a few ideas



    _________________
    Hope this helps,
    Chris


    [ This Message was edited by: Chris Davison on 2002-05-07 13:10 ]

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

    Default

    you have over done the formatting.

    limit this and your be fine/


    Free Excel based Web Toolbar available here.

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

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jack... he can't open it though....!

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

    Default

    o0k not my best post i mean your over done it killed it distroyed it broken it curupted it.

    suggest limit it.. ie dont go that rout again.

    fix... i doubt it, as many of my lost friends remember the good days.

    recover the data.. no i hope im wrong that s lost unless recovery file is made if the PC heavy crashed and had time to write it..

    sorry to miss lead you all.


    Free Excel based Web Toolbar available here.

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

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry to reopen this thread.
    One of my clients now gets this same error.

    The file isn't corrupted as everyoone else can access the spreadhsheet from their pc's.

    I think i might try and increase the virtual memory!

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry to reopen this thread.
    One of my clients now gets this same error.

    The file isn't corrupted as everyoone else can access the spreadhsheet from their pc's.

    I think i might try and increase the virtual memory!

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

    Default

    On 2002-09-05 13:42, Qroozn wrote:
    Sorry to reopen this thread.
    One of my clients now gets this same error.

    The file isn't corrupted as everyoone else can access the spreadhsheet from their pc's.

    I think i might try and increase the virtual memory!
    Qroozn

    Talk to me whats up, can the file open or is it trashed an mess?

    Jack

    PS you have shown you are on the money as far as im conserned, no sorrys needed - have you tried all your magic, and are you stuck?

    Jack

    Free Excel based Web Toolbar available here.

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

Some videos you may like

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
  •