From: C y b e r T e c h @ L i s t s . E x M a c h i n a . n e t
<http://www.cybercafe21.net> & <http://www.cybercafe21.tv>

voici l'info de help de 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




> -----Original Message-----
> From: Frédéric Médery [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 22, 2001 3:41 PM
> To:   CyberTech
> Subject:      [CCTK] nombre de ligne limite d'un fichier excel ?
> 
> From: C y b e r T e c h @ L i s t s . E x M a c h i n a . n e t 
> <http://www.cybercafe21.net> & <http://www.cybercafe21.tv>
> 
> Existe-t-il une taille max de ligne ou de taille pour un fichier excel ?
> 
> Gracias a tous ;-)
> 
> Fred
> 
> Des Cadeaux, des avantages et des offres qui vous interessent ?
> http://www.justforyou.be... what you want is what you get !
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> CCTK vous est offert par Ex Machina  <http://www.exmachina.net>
> Pour vous desabonner <mailto:[EMAIL PROTECTED]>

   




Des Cadeaux, des avantages et des offres qui vous interessent ?
http://www.justforyou.be... what you want is what you get !
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
CCTK vous est offert par Ex Machina  <http://www.exmachina.net>
Pour vous desabonner <mailto:[EMAIL PROTECTED]>

Répondre à