Hyperlinking in External Data sheet

Copper Contributor

Hello all,

 

I've created a complete RACI overview in a "master sheet" in Excel 2007 to enable me to use the External Data function to simplify the overview for specific users on "slave sheets" (but keep the possibility to update all referenced sheets from the master sheet).

 

It works perfectly, but now I want to add hyperlinks in the master sheet and have these transferred to the slave sheets.  Unfortunately, I only receive the text (not the hyperlink).

 

Is there any way of filling in hyperlinks in the master sheet and retrieving that same information in the slave sheets?

 

Thanks for any ideas in advance.

 

Ronald

0 Replies