i have the following formula:
=HYPERLINK("'"&MTEAM1&"'"&"!", "LIZ T")
the formula accepts fine, but does not work
the Value of MTEAM1 is "Liz T" and i have a sheet called "Liz T"
but when the hyplerlink is clicked it just states cannot fin specified file
any ideas on how to...