I have a workbook with 5 sheets and a total sheet for those 5 other sheets
titled "Access". We have about 20 other workbooks that this total sheet needs
to be transferred over to to run totals. When we try to copy and paste the
total sheet into the 20 other workbooks, the total sheet referrences back to
the workbook we copied it from and will not total the other workbooks. Have
tried special paste, cut, copy, move sheet, copy sheet...nothing. Any ideas
how to more the total sheet(with formulas and cell referrences) from one
workbook to another without having it referrence back to the workbook it was
copied from? All workbooks have the same sheet names(sheet1, sheet2, etc).
Excel 2003.