If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there an Excel File size limit?
I know there is a limit to the number of columns (256)
and rows (about 64,000) in a single Excel spreadsheet. But is there a limit to the number of worksheets in a file or the total size of a single Excel file? I have a very complex Excel 2000 workbook I wrote that has several hundred linked worksheets that total over 50MB in size for the file. If I open another similar Excel file that is about 40MB, Excel hangs even though I have nearly a gigabyte of memory (I had thought Excel file size was only limited by the amount of available memory). If I open a new session of Excel and then open the second workbook, both programs run fine except if I try to link or copy/paste between them - which causes Excel to crash. Is this an Excel limitation? Thanks. |
#2
|
|||
|
|||
Is there an Excel File size limit?
Number of sheets is limited by available memory, if you search help for
[Excel specifications and limits] you'll see it there among other things -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Paul" wrote in message ... I know there is a limit to the number of columns (256) and rows (about 64,000) in a single Excel spreadsheet. But is there a limit to the number of worksheets in a file or the total size of a single Excel file? I have a very complex Excel 2000 workbook I wrote that has several hundred linked worksheets that total over 50MB in size for the file. If I open another similar Excel file that is about 40MB, Excel hangs even though I have nearly a gigabyte of memory (I had thought Excel file size was only limited by the amount of available memory). If I open a new session of Excel and then open the second workbook, both programs run fine except if I try to link or copy/paste between them - which causes Excel to crash. Is this an Excel limitation? Thanks. |
#3
|
|||
|
|||
Is there an Excel File size limit?
Yes but what that does not tell you is that Excel has its own definitions of
"available memory", which vary depending what you are trying to do and which Excel version you are using. see http://www.DecisionModels.com/memlimitsc.htm Charles ______________________ Decision Models The Excel Calculation Site. www.DecisionModels.com "Peo Sjoblom" wrote in message ... Number of sheets is limited by available memory, if you search help for [Excel specifications and limits] you'll see it there among other things -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Paul" wrote in message ... I know there is a limit to the number of columns (256) and rows (about 64,000) in a single Excel spreadsheet. But is there a limit to the number of worksheets in a file or the total size of a single Excel file? I have a very complex Excel 2000 workbook I wrote that has several hundred linked worksheets that total over 50MB in size for the file. If I open another similar Excel file that is about 40MB, Excel hangs even though I have nearly a gigabyte of memory (I had thought Excel file size was only limited by the amount of available memory). If I open a new session of Excel and then open the second workbook, both programs run fine except if I try to link or copy/paste between them - which causes Excel to crash. Is this an Excel limitation? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Size of Excel file Access db exports to. | Tasha | General Discussion | 2 | June 5th, 2004 01:48 PM |
Excel 2000 will not open a file. | Jim Stephens | Setting up and Configuration | 2 | May 19th, 2004 01:15 PM |
"Excel file locked by [user]" though user is the one trying to open it! | Lady Layla | Setting up and Configuration | 0 | May 12th, 2004 02:12 PM |
"Excel file locked by [user]" though user is the one trying to open it! | CheriD. | Setting up and Configuration | 0 | May 11th, 2004 09:21 PM |
Excel file size grows | Julie E | Worksheet Functions | 1 | March 18th, 2004 08:41 PM |