Once you have copied the sheet across and the formulas
are referring to bookA...
Eg. ='[BookA]sheet1'!A1+'[BookA]sheet1'!A2
Highlight the entire new sheet, and do a replace (Ctrl H)
Find What : [BookA]
Replace With :
Leave Replace With blank and hit replace all.
Obviously you need to have a sheet called sheet1 in your
new workbook.
Check you have broken all links by going Edit / Links...
links should be greyed out. Sometime they remain if you
have copied named ranges from a previous workbook.
Hope this helps.
Paddy
-----Original Message-----
If I copy a sheet with formulas from bookA to bookb, all
formulas than point from bookB to bookA.
