Share via

Regarding Mapping of the excel file to another excel file

Utkarsha 0 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.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
1,220 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,999 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mohsin M Khan 0 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.

    1 person found this answer helpful.

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.