0

I Have an Excel of my customer, and I have to link a column to another File. In my column I can see 

=VLOOKUP(F2,'file://myfile.xlsx'#$Foglio1.$A$2:$E$65,3,)

with right Path, but if I change myfile.xlsx, my data doesn't changed.

When I do a Csv, my column doesn0t have the value of myfile.xlsx

monkeyUser
  • 4,301
  • 7
  • 46
  • 95

1 Answers1

0

There are several ways to update the cell:

  • Edit -> Links, click the Update button.

Or:

  1. Close the file and reopen it.
  2. It should ask, "This file contains links to other files. Should they be updated?" Click Yes.

Or:

  1. Open both files.
  2. Select the cell containing the VLOOKUP statement and press Ctrl+Shift+F9

After the cell is updated, make the CSV file.

Jim K
  • 12,824
  • 2
  • 22
  • 51