Updating Name References in Sheet
 

Excel 2003. I have built a multi-sheet workbook that contains names (cells
that have been given names). I add a summary sheet to this book that makes
reference to these cell names. The summary sheet was built separately and
has the name references in the appropriate places (e.g. a cell with formula
"=YTD98"). The name YTD98 has been given to a cell elsewhere in the
workbook. The summary sheet is copied to the workbook programatically. What
command or actions do I need to use so that after I copy the summary sheet
into the workbook it updates all the values for formulas that references the
named cells? Thanks for the help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org