| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Neet to use Excel to read in multiple-sheet file
I have a 118MB file which I want to have in a multiple-sheet Excel file. It
always stops and says that it could not download the whole file. When it quits at the 64KB record size, there appears no way to tell it to just go on and load the rest of the file in multiple sheets. How can I do this? Right now I am breaking the file apart by hand, but that is not at all ideal. Any help appreciated. Just try not to think I am overwhelmingly stupid. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Neet to use Excel to read in multiple-sheet file
Maybe this KB article can help you.
http://support.microsoft.com/default...;en-us;Q120596 Gord Dibben MS Excel MVP On Thu, 29 Jun 2006 08:49:02 -0700, VMetze wrote: I have a 118MB file which I want to have in a multiple-sheet Excel file. It always stops and says that it could not download the whole file. When it quits at the 64KB record size, there appears no way to tell it to just go on and load the rest of the file in multiple sheets. How can I do this? Right now I am breaking the file apart by hand, but that is not at all ideal. Any help appreciated. Just try not to think I am overwhelmingly stupid. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Neet to use Excel to read in multiple-sheet file
I was afraid that might be the case. I very much appreciate your
information. It isn't what I hoped for, but it is, at least, definitive. Thanks very much. "Gord Dibben" wrote: Maybe this KB article can help you. http://support.microsoft.com/default...;en-us;Q120596 Gord Dibben MS Excel MVP On Thu, 29 Jun 2006 08:49:02 -0700, VMetze wrote: I have a 118MB file which I want to have in a multiple-sheet Excel file. It always stops and says that it could not download the whole file. When it quits at the 64KB record size, there appears no way to tell it to just go on and load the rest of the file in multiple sheets. How can I do this? Right now I am breaking the file apart by hand, but that is not at all ideal. Any help appreciated. Just try not to think I am overwhelmingly stupid. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine multiple excel file in to one excel file and multiple worksheet | Excel Discussion (Misc queries) | |||
| "Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
| Can I embed or link multiple .pdf files into or to an excel file? | Excel Discussion (Misc queries) | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
