View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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