Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File size Limit in Excel 2003
I have a huge amount of data (more than 25 Mb) that I need to keep in an
Excel-2003 file. I am going to add 25 Mb of data to this file every month. Is there a limit to the file size in Excel-2003? At what file size can you expect a degradation in the performance on a 1.5 GHz processor with 512 MB RAM? Is there a limit to the number of work sheets that can be created in Excel-2003? Thanks Sam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File size Limit in Excel 2003
The worksheets have a limit based on the number of cells 256 x 65536 @ 156
characters per cell. But you could use many worksheets. However, I think I would look to something like Access, or another db type to store large amounts of data and just pull it out to Excel as needed. "Sam" wrote: I have a huge amount of data (more than 25 Mb) that I need to keep in an Excel-2003 file. I am going to add 25 Mb of data to this file every month. Is there a limit to the file size in Excel-2003? At what file size can you expect a degradation in the performance on a 1.5 GHz processor with 512 MB RAM? Is there a limit to the number of work sheets that can be created in Excel-2003? Thanks Sam |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File size Limit in Excel 2003
hi.
the answer to both of your questions is "limited by available system resources". meaning how big is your hard drive, memory ect. in your case with 512mb memory, i would consider doubling it. but i do like JLGWhiz's suggestion. assess would allow for better managablity potential. you may have to do some coding, forming and querying but the potential for better data management is greater than in excel. when your data get that big, you may not have exceeded excel's limits but you may exceed the human limit to manage with excel. regards FSt1 "Sam" wrote: I have a huge amount of data (more than 25 Mb) that I need to keep in an Excel-2003 file. I am going to add 25 Mb of data to this file every month. Is there a limit to the file size in Excel-2003? At what file size can you expect a degradation in the performance on a 1.5 GHz processor with 512 MB RAM? Is there a limit to the number of work sheets that can be created in Excel-2003? Thanks Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xml import....Size limit?? Can the XML file be split?? | Excel Discussion (Misc queries) | |||
File size limit | Excel Discussion (Misc queries) | |||
File size limit | Excel Discussion (Misc queries) | |||
Excel 2K on Terminal Server - File Size Limit | Excel Discussion (Misc queries) | |||
Limit on Excel 97 file size? | Excel Programming |