Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import text file into Excel 2007 then copy sheet to another workbo
I have been importing text file into Excel 2007 by using Open command. This
works fine, but when I try to copy the sheet to any other workbook, I am getting a message to say there are too many rows and columns to carry out the operation. The text file has several hundred rows, but when opened in Excel, the workbook has 1048576 rows instead of the standard 65536. This means that it will not copy to a workbook with the standard number. Is there a way round this? I do realise I can copy and paste, but would like to know the answer to the copy sheet question if possible. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import text file into Excel 2007 then copy sheet to another workbo
Save the workbook as a 97-2003 file then copy the sheet
-- Regards, Peo Sjoblom "DonnaO" wrote in message ... I have been importing text file into Excel 2007 by using Open command. This works fine, but when I try to copy the sheet to any other workbook, I am getting a message to say there are too many rows and columns to carry out the operation. The text file has several hundred rows, but when opened in Excel, the workbook has 1048576 rows instead of the standard 65536. This means that it will not copy to a workbook with the standard number. Is there a way round this? I do realise I can copy and paste, but would like to know the answer to the copy sheet question if possible. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import text file into Excel 2007 then copy sheet to another wo
Unfortunately that's not worked. My default settings in Excel were already
for saving in the older .xls format, but also did a save as 97-2003 and no improvement. "Peo Sjoblom" wrote: Save the workbook as a 97-2003 file then copy the sheet -- Regards, Peo Sjoblom "DonnaO" wrote in message ... I have been importing text file into Excel 2007 by using Open command. This works fine, but when I try to copy the sheet to any other workbook, I am getting a message to say there are too many rows and columns to carry out the operation. The text file has several hundred rows, but when opened in Excel, the workbook has 1048576 rows instead of the standard 65536. This means that it will not copy to a workbook with the standard number. Is there a way round this? I do realise I can copy and paste, but would like to know the answer to the copy sheet question if possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove shading of shapes in Excel 2007 (with an .xls workbo | New Users to Excel | |||
Excel 2007/Vista: Missing file name on import external data connection | New Users to Excel | |||
How to import html file in excel 2007 | Excel Discussion (Misc queries) | |||
Import data into Excel sheet from CSV File | Excel Discussion (Misc queries) | |||
how to import more than 1 text file into the same Excel worksheet. | Excel Discussion (Misc queries) |