How do I insert a file in to an excel document

M

Mark

I'm trying to insert an Excel file in to an Excel spread sheet and I know it
can be done, but I seem to be going round in circles. How do I embed / insert
it? Anyone help?
 
M

Max

Tinker with it like this ..
Click Insert > Object > Create from File
Then click Browse to navigate to folder,
select the excel file > Insert
Then Check "Display as icon" > OK
 
K

Kevin B

You can also insert a hyperlink to the file if all you want to do is give the
user easy access to the Excel workbook.

Click INSERT on the menu & select HYPERLINK (or press Ctrl+K).

In the dialog box, click EXISTING FILE OR WEB PAGE (the default), browse
until the file is located. Select the file & click OK if you want to link to
the file, or click the BOOKMARK command button in the dialog box and enter a
cell reference in the workbook, a sheet reference or a named range reference.
This opens the file to a specific location in the workbook.

Hope this helps.
 
M

Mike Middleton

Mark -

An Excel workbook file may contain one or more worksheets.

If you want to move or copy a worksheet from one workbook to another, open
both workbooks, right-click the worksheet tab, and choose Move Or Copy ...

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top