linking a worksheet to one in another book

[Alec Holliday]

Done this before - but cannot remember how.

Excel 2003

Workbook with 7 sheets, for wages, 1 sheet is a "master" and consists of the
totals of the other 6 sheets.
The master (plus other sheets from different workbooks needs to be sent to
payroll bureau.)
I cannot for the life of me remember how to make a sheet in a different book
update with changes from this master sheet.
I have followed the help files which suggest "paste special" but paste
special is greyed out.
Would be eternally grateful.
(and a Happy new Year to anyone who helps - and even those who do not)
Alec

 

[PowerWheels]

Done this before - but cannot remember how.

Excel 2003

Workbook with 7 sheets, for wages, 1 sheet is a "master" and consist
of the
totals of the other 6 sheets.
The master (plus other sheets from different workbooks needs to be sen
to
payroll bureau.)
I cannot for the life of me remember how to make a sheet in a differen
book
update with changes from this master sheet.
I have followed the help files which suggest "paste special" but paste
special is greyed out.
Would be eternally grateful.
(and a Happy new Year to anyone who helps - and even those who do not)
Alec

Paste special might be greyed out because you have 2 instances of Exce
open. Open one worksheet and then open the other from within Excel. Le
me know if this doesn't help