hyperlinking files

[fullymooned]

I need to hyperlink a cell to another excel file. However instead o
merely hyperlinking I need to link it to a particular tab in the file.

Workbook1.xls#Sheet1!A5 doesnt work

Any one know how

Thank yo

 

[JE McGimpsey]

Read my reply to your last post. it would help to know what you mean by
"doesnt work" - does it throw an error (if so, what does the error
message say?)? do nothing? crash XL? something else entirely?

 

[fullymooned]

a window pops up and reference is not valid is displaye