Hi BritBiker,

After copying the refernce table to the new workbook, select cell A4 then choose View>Freeze Panes>Freeze Panes. That's all there is to it. You may also want to change the zoom ratio and sheet name to match the original.

As for the external links in the "Water master excel working copies" workbook, your "Water Terminal Balance Sheet" worksheet has links to a file named "Recom Water master excel copies modified.xls". Do a Find for that and, in the cell's formula, copy everything up to and including the ], paste that into the 'Find' box and paste ' (a tick mark/single quote) into the Replace box. Do a 'Replace All' and the links should be gone.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]