A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Is there an Excel File size limit?



 
 
Thread Tools Display Modes
  #1  
Old July 8th, 2004, 02:51 AM
Paul
external usenet poster
 
Posts: n/a
Default 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  
Old July 8th, 2004, 03:05 AM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default 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  
Old July 8th, 2004, 08:41 AM
Charles Williams
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 09:41 PM


All times are GMT +1. The time now is 11:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.