Excel: Hyperlinks to same worksheets

[AJD10]

Hopefully this is easy.

I have hyperlinks on Sheet1 that will take the person to Sheet2, Sheet3, etc.

When I add the hyperlink, the URL is "file://C:\My Documents\Status.xls\Sheet2!A1".

The challenge is that I will be emailing this spreadsheet daily to multiple users (including client office).

So, how do I set up the hyperlinks to read just the current document name (wherever it is) with the specific worksheet names? I found set up hyperlink base in File/Properties, but I'm not sure about that.

There are multiple hyperlinks so this can't be updated every time.

Thanks!

 

[SkipVought]

Your hyperlink should be
[tt]
#Sheet2!A1
[/tt]
Use Edit/Replace to fix.

Skip,
[sub]
[red][/red]
[/sub]