Reference is not valid when trying to link to a worksheet in doc.
 

I'm running MS Excel 2008 for Mac v.12 - When I edit a cell to hyperlink to
another worksheet in the same file, it works fine until I save, close and
re-open the file - which is when I get the Reference is not valid error
message upon clicking it again. It works fine on my PC but I need this
function to work on my Mac, can you help? Much thanks.