I have a few work books that can use the same sheet. if I copy the
sheet from one work book to another, I have to go into all the
formulas and remove the referance to the old work book.

is there any way to copy the sheet over and have it work in the new
workbook without reduing all the formulas?

Thanks for your help

Wally