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 |
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 |
All times are GMT +1. The time now is 04:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com