How is excel able to fetch data from a file that is linked but doesn't exist on the same computer? Product Office365

anand shrivastava 1 Reputation point
2020-10-15T05:22:06.61+00:00

I had moved an excel file with link to another excel file to a different computer. Yet when I pull data from the other file the data is fetched. How is it doing that. I checked the link in the formula and it points to file on my previous computer. How do I get access to the source file if I have to update any data.

Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
464 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 22,086 Reputation points Microsoft Vendor
    2020-10-15T08:57:30.607+00:00

    Hi @anand shrivastava ,

    I suggest you refer to this support article about Description of link management and storage in Excel:

    https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel

    Hope it's helpful.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments