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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 10:29 AM |