Open the file referenced in the formula

[msohail]

Hi,
Is there an automatic way to open the file to which the formula is referencing?

Thanks,

 

[GlennUK]

What's the formula?

( direct linking formulae can be used to automatically open the referenced file by firstly switching off Edit Directly In Cell option, of Tools/Options/Edit, and then double-clicking the cell )

 

[msohail]

=+'DeNDRoN LRNs'!N5/1000

I want to open the file /workbook 'Dendron LRNs', I don't know where it is located.

Thanks,

Mohammed

 

[GlennUK]

Follow my instructions.

 

[msohail]

Hi,
I have switched off the 'edit directly in cell' option, how do I now go about opening the source file please?

Apologies if I'm missing something here, nto good at Excel, as u can tell!


Thanks,

 

[GlennUK]

Try double-clicking the cell now.

 

[Andrew Poulsom]

That formula references a worksheet in the same workbook, not another workbook.

 

[msohail]

got it! thanks, the sheet was hidden!

Its useful to know though that another file can be opened from the formula too, thanks guys!

ta