The way I normally copy a sheet to another book is just do right-click on
the sheet tab, and follow the pop-ups, selecting to copy, and paste to
another filename.........however, if the original sheet has links to other
sheets in the original book, you will get the #REF! errors.........only way
around that is to edit the respective formulas.....

hth
Vaya con Dios,
Chuck, CABGx3



"Miri" wrote:

hi,
i would like to have the data of one sheet in other excel file.
i left the sheet name but delete all the data and names of it.and put it in
other excel file(lets call it Data file).
i created a macro that open the Data file and copy it to the original
existing tab.
i have #REF problems in other sheets that suppose to use the data. it might
be Naming problem.
do you have an idea how should i solve it?
I tried also to leave the names in the original file. but ref problems still
exist....
--
Miri Tz.