Thread: [Solved] Using Reference Tables in calculations
View Single Post
 
Old 02-15-2013, 04:19 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote