excel 97 problem

[storm]

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

[gareth]

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?

[Chris Davison]

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 ]

[Jack in the UK]

you have over done the formatting.

limit this and your be fine/

[Chris Davison]

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

[Jack in the UK]

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.

[Qroozn]

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]

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!

[Jack in the UK]

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