D
Deanna
I have two types of links in my workbook:
1)external links to a SharePoint web folder containing
HTML files and;
2) links to defined names within the workbook.
The SharePoint address is rather lengthy and can change,
so I set this as the hyperlink base in my workbook's
properties. However, after I do this, none of my links for
defined names work. The base address is appended to the
defined name reference. Is there any work-around for this?
I was hoping it might be as simple as enclosing the
defined name in quotes, but, of course, it wasn't that
simple. Any ideas?
1)external links to a SharePoint web folder containing
HTML files and;
2) links to defined names within the workbook.
The SharePoint address is rather lengthy and can change,
so I set this as the hyperlink base in my workbook's
properties. However, after I do this, none of my links for
defined names work. The base address is appended to the
defined name reference. Is there any work-around for this?
I was hoping it might be as simple as enclosing the
defined name in quotes, but, of course, it wasn't that
simple. Any ideas?