Share via

Regarding Mapping of the excel file to another excel file

Utkarsha 20 Reputation points
2024-12-25T11:53:59.0766667+00:00

We have 1 case where user have mapped the excel file to another excel file using VLOOKUP formula, but now the original file which was mapped to another excel file is being deleted and cannot be restored.
Here question is, If the original excel file which is mapped to another excel file is deleted, still how does the data gets fetched in another excel file.

Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | OneDrive | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
0 comments
Accepted answer
  1. Mohsin M Khan 85 Reputation points
    2024-12-25T14:47:28.1333333+00:00

    Hi,

    Excel maintains a cached copy of the data fetched by formulas like VLOOKUP. This cache stores the last successfully retrieved data from the source file.

    If the original file (source file) is deleted, Excel continues to show the last fetched value from its cache as long as the dependent file (destination file) is not recalculated or refreshed.

    Try to Open the dependent file and navigate to Data > Edit Links. Break the link to the original file to preserve the current values as static data.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.