View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default overflow-how big a file can Excel handle?

Everything you ever wanted to know but were affraid to ask..

http://www.decisionmodels.com/index.htm
--
HTH...

Jim Thomlinson


"John Smith" wrote:

When trying to run a vb script, I got an error message saying
overflow. The file is about 4 Mb with about 35900 rows and 6
columns. I had to cut half of the rows and pasted them to a new
file. Then, the script ran without problems. It seems to me that
Excel hit a limit on the file size, row number or something.

I wonder if the problem is due to my computer or Excel. Anyone has
any idea?