Forum Discussion
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 worksheet?
Allan
24 Replies
- 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.
Hi Wyn,
Many thanks for your prompt reply.
Is there a way of doing it without modifying the source file?
Allan
Do you have a version of Excel with the =FORMULATEXT function available?
