How to import worksheet from another workbook?

[Ke Lu]

If I copy entire worksheet and paste it to another workbook, it just paste
the link to another worksheet because it will ask me if I need to update the
link every time I open the workbook.

Could you tell me if there is another way to import worksheet from another
workbook?

Thanks for your help.

 

[Andy B]

Hi

One way is to select your range and copy. Go to the new workbook and Edit /
Paste Special . . . Values. This will simply paste the values of the cells -
which means that any formulas on the sheet will be lost too, being replaced
by their values instead.

 

[Peo Sjoblom]

And if you need formulas but don't want the external link, do edit>replace
and replace = with for example a=
then copy, then reverse on both sheets and replace a= with =

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)