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
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Sep 16, 2017
I would enter the source filename into a named cell (e.g. SOURCENAME) in the source file and then simply reference that directly ='Demo 1.xlsx'!SOURCENAME in the current workbook. There are some other ways but that's by far the simplest.
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