Inserting a worksheet from external workbook

Is it possible to insert a worksheet from an external workbook into my
current workbook? This needs to end up as a regular sheet, not an embedded
object.

Thanks

If you want to copy the sheet, first make a copy in the original workbook,
then, on the copy, do a Replace All - replace all instances of = with some
unlikely string such as #### . Then copy the sheet to your new workbook,
rename it, then reverse the Replace All - replace all instances of ####
with = - this ensures Excel doesn't try to reference the original workbook
in your formulas.

HTH

Dan
"Hall" <hall@garp.org> wrote in message
news:%23fc0%23veGFHA.3912@TK2MSFTNGP10.phx.gbl...
> Is it possible to insert a worksheet from an external workbook into my
> current workbook? This needs to end up as a regular sheet, not an
> embedded
> object.
>
> Thanks
>
>

You could copy it to a different workbook, but then you have two worksheets in
two different workbooks. These worksheets are connected anymore. (If you
change A1 in one worksheet in workbook 1, then it doesn't change A1 in the
copied worksheet in workbook 2.)

Rightclick on the worksheet tab and select
Move or Copy...
(remember to check the Copy box!)

(You have to have both workbooks open, too.)

Hall wrote:
>
> Is it possible to insert a worksheet from an external workbook into my
> current workbook? This needs to end up as a regular sheet, not an embedded
> object.
>
> Thanks

--

Dave Peterson