Results 1 to 2 of 2

Thread: Named Formula

  1. #1
    Cecil Rhoades

    Named Formula

    I would like to use the following formula
    M:MyShare[MyFile.xls]Teams'!$A$2 in a named range.
    This formula works fine in a cell, with the Myfile.xls open or closed. However, it only works in the named range when the spreadsheet MyFile.xls is open.

    Am I stuck with this behavior?

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Reading/Swindon, Berkshire, United Kingdom
    Thanked 0 Times in 0 Posts

    Re: Named Formula

    I don't understand why you're having problems. You may well need the workbook that the link in the named range points at to be open when you establish the link, but after that you should be okay. Did you go insert/name/define, type "mylink" in the top box, click on the refedit button to the right of the bottom box, navigate to the other workbook/sheet/cell required + select it, click on the refedit button again and click okay? If yes, I'm not sure whether I can suggest anything else.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts