View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
snax500
 
Posts: n/a
Default Excel links in Word

In Word2000, I want to insert many Excel2000 links into a monthly
letter. I know how to do this Copy-PasteSpecial Unformatted text -
Link. The porblem is that once I modify to the next month, I need to
change the Excel tab link to the next month. How can I do this easily.
For example, in the Excel file, I have the following monthly tabs, Jan,
Feb, Mar, etc. I link the data to the Jan monthly letter. Once the next
month (Feb) comes around how do I change all these links to the Feb tab
in the same Excel file?

Thanks