View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Smith John Smith is offline
external usenet poster
 
Posts: 62
Default overflow-how big a file can Excel handle?

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?