RE: Link to Excel table with filtering enabled

Subject: RE: Link to Excel table with filtering enabled
From: "Weissman, Jessica R" <WeissmanJR -at- state -dot- gov>
To: John Posada <jposada99 -at- gmail -dot- com>, Tech Writers <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Mon, 4 Jun 2018 17:47:56 +0000


I think you'd have to do this with a Word macro that calls Excel and passes parameters that indicate which entries to show. On the Excel side it would filter the big table and make a temporary sheet with the filtered results. The link in the Word doc would be a button that executes the macro to do all this.

Might not be worth the trouble to create or maintain. Why not just copy the relevant items manually into each Word doc?

If you think you'd be revising the glossary wording and want to keep it updated, you might be able to transfer the Excel sheet into a Word doc and use bookmarks to grab current text.

Disclaimer: these are just ideas and there may well be a much simpler way to do it. No matter what way you chose, you'd need to find a way to indicate which glossary items are relevant for the document.

- Jessica

Visit TechWhirl for the latest on content technology, content strategy and content development |


You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-leave -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit for more resources and info.

Looking for articles on Technical Communications? Head over to our online magazine at

Looking for the archived Techwr-l email discussions? Search our public email archives @


Link to Excel table with filtering enabled: From: John Posada

Previous by Author: Re: First days and weeks on the tech writing job
Next by Author: RE: Consistency with screenshots
Previous by Thread: Link to Excel table with filtering enabled
Next by Thread: Re: Link to Excel table with filtering enabled

What this post helpful? Share it with friends and colleagues:

Sponsored Ads