=HYPERLINK("[Budget.xls]June!E56",E56)

Worked for me.

--
Regards,
Tom Ogilvy


"hyperlink with name from cell" wrote:

I created a "Budget" workbook with June, July, & August workshhets, and added
the following hyperlink in August. I got a pop-up saying "Cannot open the
specified file". What am I doing wrong?
=HYPERLINK("[Budget]June!E56", E56)

"Tom Ogilvy" wrote:

maybe check out David McRitchie's site on building a TOC with hyperlinks:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

--
Regards,
Tom Ogilvy



"hyperlink with name from cell" wrote:

I have a workbook with 300 worksheets. I just created a dropdown to get to
a specific worksheet fast. But, I have just read about using hyperlinks and
I am intrigued! My first page is set up like a TOC (cell A1 to A300
"=NameOfSheet!B2"). I would like to set up a hyperlink for each sheet and
have the text from a certain cell show up as the name. In the end I would
like to go to my TOC page, click on a name, and then be taken to the
appropriate sheet. This is all new to me.....I am using XL200. Thanks!