Inserting a worksheet from external workbook

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

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
 
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.)
 
Back
Top