Prev: How do I stop a Pivot Table from Sorting my data (Excel 2007)
Next: Some recalcitrant custom cell styles
From: JJ on 26 Apr 2010 10:16
Can I use hyper link in one cell but link to more than one external data
files? If not, how can it be done?
From: Jacob Skaria on 26 Apr 2010 10:23
If you mean to display multiple links in the same cell based on a condition
then Yes; as below...

=HYPERLINK(IF(B1="Yes","c:\1.txt","c:\2.txt"))

--
Jacob (MVP - Excel)


"JJ" wrote:

> Can I use hyper link in one cell but link to more than one external data
> files? If not, how can it be done?
 | 
Pages: 1
Prev: How do I stop a Pivot Table from Sorting my data (Excel 2007)
Next: Some recalcitrant custom cell styles