• #VALUE when referencing an unopen link

    Author
    Topic
    #495667

    I have a file that contains “Sumif” formulas that link to an unopened file. Whenever I open the file that contains the “Sumif” formulas first, without having opened the “source” file (i.e., the file that contains the data in the Sumif formula), I get a #VALUE. Any ideas how to fix?

    Viewing 0 reply threads
    Author
    Replies
    Viewing 0 reply threads
    Reply To: #VALUE when referencing an unopen link

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: