Thread: Charts still linked to old book.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fan924 Fan924 is offline
external usenet poster
  
Posts: 238
Default Charts still linked to old book.
Excel 97. Macro copies data and a dozen charts to a new workbook.
Charts still linked to old book. Can I change book and sheet to the
new sheet automatically? Search and replace?

Reply With QuoteReply With Quote