ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert an excel file into the current open excel file (https://www.excelbanter.com/excel-discussion-misc-queries/128016-insert-excel-file-into-current-open-excel-file.html)

MAECR

Insert an excel file into the current open excel file
 
Office 2002

When I am in word, I can "insert" a file into the file I am presently
working on.
I simple click on INSERT & select file.

I do not see this option in Excel but it would really be helpful.

Any suggestions on how I can insert an excel file into the excel file
currently being worked on?

MR

Nick Hodge

Insert an excel file into the current open excel file
 
MR

Can you not just move or copy the sheets in?

EditMove or copy sheet...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"MAECR" wrote in message
...
Office 2002

When I am in word, I can "insert" a file into the file I am presently
working on.
I simple click on INSERT & select file.

I do not see this option in Excel but it would really be helpful.

Any suggestions on how I can insert an excel file into the excel file
currently being worked on?

MR



Dave Peterson

Insert an excel file into the current open excel file
 
You can choose Insert|Object|Create from file tab

But this is pretty unusual. Most people won't embed an excel workbook into
another excel workbook.

Is that really what you want to do?

MAECR wrote:

Office 2002

When I am in word, I can "insert" a file into the file I am presently
working on.
I simple click on INSERT & select file.

I do not see this option in Excel but it would really be helpful.

Any suggestions on how I can insert an excel file into the excel file
currently being worked on?

MR


--

Dave Peterson


All times are GMT +1. The time now is 06:54 AM.

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