I'm using a hyperlink in one workbook to go to another workbook in a specific
cell location. I receive message "Reference not valid".

I created this hyperlink by selecting Insert--Hyperlink and choose existing
file. I appended #Public Service!D4 to the file address so it will navigate
to the specific cell location (D4) in Sheet Public Service.

Any help would be appreciated. Thank you.

You probably need to use append #'Public Service'!D4 (add single quotes)
instead of #Public Service!D4. If you are just making changes to the cell
value then underlying link does not change...

The right way to insert hyperlink is given below;
"To link to a location in another workbook, choose Existing File or Web
Page. Once you have located the workbook you with to link to, select the
Bookmark button and in the list under Cell Reference, select the sheet you
wish to link to, and in the Type in the cell reference box, enter in the cell
reference number. Click OK. If you have given your cells a defined name, then
in the list under Defined Names, click the name of the range you wish to link
to and click OK. "

"Tesons" wrote:

I'm using a hyperlink in one workbook to go to another workbook in a specific
cell location. I receive message "Reference not valid".

I created this hyperlink by selecting Insert--Hyperlink and choose existing
file. I appended #Public Service!D4 to the file address so it will navigate
to the specific cell location (D4) in Sheet Public Service.

Any help would be appreciated. Thank you.

Thank you very much. It worked! And thank you for posting the proper way to
insert a hyperlink. I did not realize I needed to use the Bookmark button.
Thanks for your time.

"Sheeloo" wrote:

You probably need to use append #'Public Service'!D4 (add single quotes)
instead of #Public Service!D4. If you are just making changes to the cell
value then underlying link does not change...

The right way to insert hyperlink is given below;
"To link to a location in another workbook, choose Existing File or Web
Page. Once you have located the workbook you with to link to, select the
Bookmark button and in the list under Cell Reference, select the sheet you
wish to link to, and in the Type in the cell reference box, enter in the cell
reference number. Click OK. If you have given your cells a defined name, then
in the list under Defined Names, click the name of the range you wish to link
to and click OK. "

"Tesons" wrote:

I'm using a hyperlink in one workbook to go to another workbook in a specific
cell location. I receive message "Reference not valid".

I created this hyperlink by selecting Insert--Hyperlink and choose existing
file. I appended #Public Service!D4 to the file address so it will navigate
to the specific cell location (D4) in Sheet Public Service.

Any help would be appreciated. Thank you.

It sounds like the hyperlink you created may not be pointing to the correct location or the file path may be incorrect. Here are a few steps you can take to troubleshoot the issue:

1. Double-check the file path: Make sure the file path you entered in the hyperlink is correct and the file is located in the specified location. If the file has been moved or renamed, the hyperlink may no longer work.
   
2. Check the sheet name and cell reference: Make sure the sheet name and cell reference in the hyperlink are correct. If the sheet name or cell reference has been changed, the hyperlink may not work.
   
3. Try creating a new hyperlink: If the above steps don't work, try creating a new hyperlink. Select the cell where you want to create the hyperlink, then go to Insert Hyperlink. Choose "Existing File or Web Page" and browse to the file you want to link to. Make sure to append the sheet name and cell reference to the file path as before.
   
4. Check for special characters: If the sheet name or cell reference contains special characters, such as spaces or punctuation marks, make sure to enclose them in single quotes. For example, if the sheet name is "Public Service" and the cell reference is "D4", the hyperlink should be:
   Formula:

   'Public Service'!D4 


Hopefully one of these steps will help resolve the issue with your hyperlink. Let me know if you have any other questions or if there's anything else I can help with.