Forum Discussion

Allan Gobolos's avatar
Allan Gobolos
Copper Contributor
Sep 15, 2017

Excel lniks to other workbooks

I am linking data from another workbook into my current worksheet.  Can I show the file name I'm linking to in my current workbook?  That is, can I link the source filename into a cell in my current ...
BI & Data Analytics
Need Help
Allan Gobolos's avatar
Allan Gobolos
Copper Contributor
Sep 18, 2017

Hi Wyn,

 

Many thanks for your prompt reply.

Is there a way of doing it without modifying the source file?

Allan

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Sep 18, 2017

Do you have a version of Excel with the =FORMULATEXT   function available?

  • Allan Gobolos's avatar
    Allan Gobolos
    Copper Contributor
    Sep 19, 2017

    Hi Wyn,

    Thanks for your message and apologies for the late reply.  Yes, I have FORMULATEXT.  I have 2013 Home and Business.

    Allan

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Sep 19, 2017

      Hi Allan

       

      I'm sure there must be a simpler way than this, but this does work regardless of whether the source file is open or closed.   The Yellow cell represents a formula that refers to a named range on another file  (I've used the named cell "NumberOfYears" for example)

       

Resources