View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gant Gant is offline
external usenet poster
 
Posts: 1
Default relative defined name references?

I'm trying to copy an excel template that has naming references included.
Is there a way to copy the template to a new worksheet within the existing
spreadsheet, but have the naming references be relative (pointing to the
current worksheet) as opposed to absolute (pointing to the previous
worksheet)?