In the 2003 version of Excel, when importing a text file, you were able to
specify a row to start the import and the text would jump to that row. That
is not happening in Excel 2007. Any one have any ideas/suggestions that I
may not know about?

I just ran through the Import process on both versions (XL2003 and XL2007)
and, except for where in the dialog boxes the information is presented, both
versions offer the identical settings. The row number I *think* you are
referring to is the row number to start at in the file you are importing;
the cell at which to begin pasting the data is asked for in a separate
dialog box that comes up when you click the Finish button from the 3-step
first dialog box. So, I'm not entirely sure what you are seeing that is
different.

--
Rick (MVP - Excel)


"Terri Farm" <Terri wrote in message
...
In the 2003 version of Excel, when importing a text file, you were able to
specify a row to start the import and the text would jump to that row.
That
is not happening in Excel 2007. Any one have any ideas/suggestions that I
may not know about?

This is in the first step of importing a text file. The row can be
specified. Some of the reports I import have the data I need say in row
3000. In Excel 2003, when I input 3000 in row, the text shown in the box
would scroll down to that row and I could start importing and be able to see
the way I want the columns imported. In Excel 2007, the box does not scroll
down to row 3000 so I have no idea how I can determine the way I want to
import the columns without scolling manually to that row.

"Rick Rothstein" wrote:

I just ran through the Import process on both versions (XL2003 and XL2007)
and, except for where in the dialog boxes the information is presented, both
versions offer the identical settings. The row number I *think* you are
referring to is the row number to start at in the file you are importing;
the cell at which to begin pasting the data is asked for in a separate
dialog box that comes up when you click the Finish button from the 3-step
first dialog box. So, I'm not entirely sure what you are seeing that is
different.

--
Rick (MVP - Excel)


"Terri Farm" <Terri wrote in message
...
In the 2003 version of Excel, when importing a text file, you were able to
specify a row to start the import and the text would jump to that row.
That
is not happening in Excel 2007. Any one have any ideas/suggestions that I
may not know about?