Import File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 29 Jul 2006 14:13 GMT

I have office 2003 excel. There is no "Import File" commands in any of
the menus. Is that normal or do I have something set up wrong?

I have open workbook. Click on blank sheet 2. Then I want to import
another excel sheet from another workbook.

John

Reply to this Message

SteveW - 29 Jul 2006 14:21 GMT

Open the other workbook

The on each sheet you need in the 2nd book, right clik on the sheet tab
And this will let you move or copy each sheet to whereever you want in the
first one.

Steve

> I have office 2003 excel. There is no "Import File" commands in any of
> the menus. Is that normal or do I have something set up wrong?
[quoted text clipped - 3 lines]
>
> John

Reply to this Message

Gord Dibben - 29 Jul 2006 17:12 GMT

John

You will find the "Import" on the Data menu.

Data>Import External Data.

Gord Dibben MS Excel MVP

>I have office 2003 excel. There is no "Import File" commands in any of
>the menus. Is that normal or do I have something set up wrong?
[quoted text clipped - 3 lines]
>
>John

Reply to this Message

Ken Wright - 30 Jul 2006 17:38 GMT

You can also just open up both workbooks, tile them so you can see them both
and then just click on the tab and drag it from one to the other. Hold down
CTRL whilst doing it to copy, or don't and it will move it.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

>I have office 2003 excel. There is no "Import File" commands in any of the
>menus. Is that normal or do I have something set up wrong?
[quoted text clipped - 3 lines]
>
> John

Reply to this Message

Rate this thread: