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 » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Maximum Size of Excel Files



 
 
Thread Tools Display Modes
  #1  
Old October 26th, 2004, 09:51 PM
external usenet poster
 
Posts: n/a
Default Maximum Size of Excel Files

Hi:
In absence of a database I am trying to create
a "Mockbase" Excel file that works on the basis of
VLOOKUP tables.

However I am ending up with files which are 40MB and up!
What is the tipping point for an Excel file? At what size
do these spreadsheets become unstable?

Please help!
  #2  
Old October 27th, 2004, 02:07 PM
Frank Stone
external usenet poster
 
Posts: n/a
Default

hi,
in theory there is no limit to the size of an excel file.
there are real world constrants like hard drive size,
amount of memory ect. There are limits on number of lines
and columns but not sheets. I have never heard of anyone
saying anything about unstable due to size but I have
heard of things like slow to load, long time to save,
error messages about low on resorces(memory) ect.
Regards
Frank
-----Original Message-----
Hi:
In absence of a database I am trying to create
a "Mockbase" Excel file that works on the basis of
VLOOKUP tables.

However I am ending up with files which are 40MB and up!
What is the tipping point for an Excel file? At what size
do these spreadsheets become unstable?

Please help!
.

  #3  
Old October 28th, 2004, 01:12 AM
Gord Dibben
external usenet poster
 
Posts: n/a
Default

OP

See Charles Williams' site for help on file size and speed and optimization
and stuff.

http://www.decisionmodels.com/optspeedb.htm

Gord Dibben Excel MVP

On Wed, 27 Oct 2004 06:07:21 -0700, "Frank Stone"
wrote:

hi,
in theory there is no limit to the size of an excel file.
there are real world constrants like hard drive size,
amount of memory ect. There are limits on number of lines
and columns but not sheets. I have never heard of anyone
saying anything about unstable due to size but I have
heard of things like slow to load, long time to save,
error messages about low on resorces(memory) ect.
Regards
Frank
-----Original Message-----
Hi:
In absence of a database I am trying to create
a "Mockbase" Excel file that works on the basis of
VLOOKUP tables.

However I am ending up with files which are 40MB and up!
What is the tipping point for an Excel file? At what size
do these spreadsheets become unstable?

Please help!
.


 




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
Excel 2003 wont convert my quattro pro files NICK KOSOR General Discussion 1 September 2nd, 2004 08:24 PM
Product Key for Office XP P.G.Indiana Setup, Installing & Configuration 1 June 7th, 2004 03:22 AM
Size of Excel file Access db exports to. Tasha General Discussion 2 June 5th, 2004 01:48 PM
Problem Opening Excel files Paul Bull Setting up and Configuration 2 November 9th, 2003 11:29 AM


All times are GMT +1. The time now is 08:51 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.