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.