Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Restrictions on size of XL file?
Hi,
Are there any restrictions on the size of an excel file? I am putting together a large workbook (15 tabs, each with about 1000 lines in them, with most cells performing lookup calculations), which will constantly be added to, and (as ever!) its critical that this workbook works correctly. Is there any sort of critical limit, or will the workbook just start to get slower the more it fills up? Thanks, Will |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Restrictions on size of XL file?
Will
Have a look at Help "specifications" for limits. Workbook size is pretty well limited by resources on your computer. Note the 200 to 250 number formats limits and the 4000 styles limits also. Gord Dibben MS Excel MVP On Mon, 16 Jan 2006 09:35:01 -0800, "will" wrote: Hi, Are there any restrictions on the size of an excel file? I am putting together a large workbook (15 tabs, each with about 1000 lines in them, with most cells performing lookup calculations), which will constantly be added to, and (as ever!) its critical that this workbook works correctly. Is there any sort of critical limit, or will the workbook just start to get slower the more it fills up? Thanks, Will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why did my Excel file suddenly balloon in size? | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
excel file size bloat | Excel Discussion (Misc queries) |