#1   Report Post  
Old April 11th 06, 07:24 PM 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


  #2   Report Post  
Old April 11th 06, 07:36 PM posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Excel links in Word

Lets say you have a special tab called "current" which is a simple copy of
the most recent month. So if April is the current month, then "current"
would just be a copy of the April tab.


Now when you insert your links they should point to "current". This way you
will never have to update the links.
--
Gary's Student


"snax500" wrote:

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel cannot establish a DDE with WORD rmoritzky Excel Discussion (Misc queries) 0 December 18th 05 02:16 PM
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM
Entering Excel information into MS Word dwalsh77 Excel Discussion (Misc queries) 0 April 8th 05 05:29 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017