File Sharing Problems

Use VLOOKUP in a Co-Authored Excel Workbook with a Server Workbook

Kushani NimanthikaKushani Nimanthika Nov 18, 2026 869 views

Question details

The user wants to use VLOOKUP in a co-authored Excel workbook to retrieve data from another workbook stored on a server or desktop.

Use VLOOKUP in a Co-Authored Excel Workbook with a Server Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
A shared workbook needs to look up values in a separate workbook using an external reference.
Observed behavior
The lookup should return data from the source workbook, but external links may behave differently in desktop Excel and Excel for the web.
Before you start

Confirm that you can open both workbooks and that the source workbook contains the lookup values in the first column of the intended range. Check that collaborators who need to refresh the link can access the source file at the referenced location.

Solution 1Recommended

Create the External VLOOKUP Link in Desktop Excel

Use desktop Excel to create and update the lookup when the source workbook is accessible on a server or local drive.

1
Open both workbooks

Open the co-authored workbook in the Excel desktop application, then use File > Open to open the source workbook from its server or local location.

2
Start the lookup formula

In the co-authored workbook, select the result cell and type =VLOOKUP(A2, replacing A2 with the cell containing your lookup value.

3
Select the source range

Type a comma, switch to the source workbook, and select the table range. Return to the formula and complete it with the return-column number and FALSE for an exact match, such as =VLOOKUP(A2,'[Source.xlsx]Sheet1'!$A$2:$C$100,2,FALSE).

4
Save and update the link

Press Enter and save the co-authored workbook. When reopening it, follow any prompt to update links to the trusted source workbook, or use Data > Workbook Links or Data > Edit Links, depending on your Excel version.

Create the External VLOOKUP Link in Desktop Excel
Access matters for collaborators: A link to a file on one person's desktop may not be accessible to other collaborators. Use a shared location they can reach, and check the link path if the source file is moved.
Free Microsoft Office alternative

Work with VLOOKUP Tables in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files to work with lookup tables and migrate everyday spreadsheet tasks without leaving familiar formats. It does not fix external-link behavior in Excel for the web.

Use VLOOKUP to retrieve values from spreadsheet tables.Open and save Microsoft Excel formats such as XLSX.Navigate spreadsheets in a familiar, easy-to-use interface.Use a free, lightweight office suite for everyday document work.
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel for the web update a VLOOKUP linked to another workbook?

External workbook links may not work or update reliably in Excel for the web, depending on the source and the available features. Open the workbook in desktop Excel and update the link there if the web result is unavailable or stale.

Why can't another collaborator refresh my VLOOKUP?

The source path may point to a file on your desktop or to a location the collaborator cannot access. Check Data > Workbook Links or Data > Edit Links and make sure the source is available to the people who need to update it.

How do I point an existing link to a downloaded source file?

In desktop Excel, open Data > Workbook Links or Data > Edit Links, select the source, and use the option to change its source. Choose the downloaded workbook and verify the lookup results.

What should I check if VLOOKUP returns the wrong value?

Check that the lookup value is in the first column of the selected source range and that the return-column number is correct. Use FALSE as the final argument when you need an exact match, and update the external link if the source data has changed.