Results 1 to 3 of 3

Thread: Formula is pulling data from deleted file ? [or #REF error not showing up]
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2018
    Posts
    53
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Formula is pulling data from deleted file ? [or #REF error not showing up]

    So yeah I used basic cell reference to other workbook, then I deleted this workbook, but numbers stayed ?
    When I try renter this formula, all it asks me is to find file path, once I cancel it just take numbers from deleted file.
    I was expecting it to give an Error..

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,908
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Formula is pulling data from deleted file ? [or #REF error not showing up]

    Yes that is how Excel behaves

    Excel remembers values for all references already in the workbook even after the other workbook has been deleted
    eg if this was already in the workbook it returns the original value
    ='C:\TestArea\[DeletedFile.xlsx]Sheet1'!$A$1

    and the value is also returned if the same formula is placed in a different cell

    Excel cannot find a new reference in the deleted workbook
    - a NEW reference returns an error
    ='C:\TestArea\[DeletedFile.xlsx]Sheet1'!$A$2
    and this returns an error
    ='C:\TestArea\[DeletedFile.xlsx]Sheet2'!$A$1

    How do I make Excel forget?
    - delete the reference
    - save the workbook
    - close the workbook
    - reopen

  3. #3
    Board Regular
    Join Date
    Jun 2018
    Posts
    53
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula is pulling data from deleted file ? [or #REF error not showing up]

    Thank you,
    Weird behavior, didn't expect Excel to work this way.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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