| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
overflow-how big a file can Excel handle?
"overflow" is generally more a variable than a memory problem. e.g. using an integer to loop thru ranges... will error out at 32k (the maximum positive value of an integer. change variable to a long should fix it. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Buffer Overflow in Excel | Excel Worksheet Functions | |||
| How large can a file get before it is too big for Excel to handle? | Excel Discussion (Misc queries) | |||
| what is "fill handle". i don't see any fill handle in my excel | New Users to Excel | |||
| need way to handle large csv imports that overflow cell size | Excel Discussion (Misc queries) | |||
| Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
Hybrid Mode
