| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Max file size for Excel to open??
At 600 MB you are probably better off using a database than XL. XL is just
not built to handle that size... Check out this link for info on memory and such... http://www.decisionmodels.com/index.htm -- HTH... Jim Thomlinson "E-Double" wrote: We have a user who is trying to import 600MB (yes Megabytes) of data into an Excel speadsheet. The person said that they got an error message when trying to do this the first time, but does not remember what the error message stated. So we tried it again and it apparently is populating the book but takes hours. Is there a maximum file/data size that one should try and import/open in Excel? And also, are there any 'tricks' to enhance the performance of Excel when attempting such a process? TIA ... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Max file size for Excel to open??
Perfect, thanks ! You are correct about the database thing, I did not even
think of that. e. "Jim Thomlinson" wrote: At 600 MB you are probably better off using a database than XL. XL is just not built to handle that size... Check out this link for info on memory and such... http://www.decisionmodels.com/index.htm -- HTH... Jim Thomlinson "E-Double" wrote: We have a user who is trying to import 600MB (yes Megabytes) of data into an Excel speadsheet. The person said that they got an error message when trying to do this the first time, but does not remember what the error message stated. So we tried it again and it apparently is populating the book but takes hours. Is there a maximum file/data size that one should try and import/open in Excel? And also, are there any 'tricks' to enhance the performance of Excel when attempting such a process? TIA ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel spreadsheet won't open full size. | Excel Discussion (Misc queries) | |||
| Excel 2007 doesn't open to full size | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
Hybrid Mode
