ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Neet to use Excel to read in multiple-sheet file (https://www.excelbanter.com/excel-worksheet-functions/96857-neet-use-excel-read-multiple-sheet-file.html)

VMetze

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.

Gord Dibben

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.



VMetze

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.





All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com