Access to linked file on excel.

[Welly]

Hi Guys,

I'm trying to enable the function where when you double click on a cell that has a link to another sheet of file and that sheet or file automatically opens to the linked cell. This is not the Hyperlink function. I had this on my last P.C but it's not enabled on my current one.

Can anyone help?

Welly

 

[Richard Schollar]

Hi Welly

Go Tools>Options>Edit tab and uncheck "Edit directly in cell".

Best regards

Richard

 

[Welly]

You're a legend. Thanks Richard.