Ask Your Question

Link to external file for dropdown list

asked 2020-07-23 20:31:31 +0200 gravatar image

Hey Gang:

I'll try again.

FILE A contains some formatted data. FILE B contains a list of cities.

I need to reference the cities in FILE B in order to populate a cell in FILE A.

How do I reference/link the list in FILE B??????

Thanks, Rich Ramik

edit retag flag offensive close merge delete


It is my understanding that you want to link to data stored inside an external secondary spreadsheet, is this correct?

lazarus477 gravatar imagelazarus477 ( 2020-07-24 02:16:11 +0200 )edit


FILE A will have the link to the drop down list that is stored in FILE B (city names).

Ideally, the list in FILE B will be seen in FILE A, then select the appropriate city. gravatar ( 2020-07-27 17:27:33 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2020-07-23 21:59:45 +0200 gravatar image

I followed your instructions, but ended up with an error reference. See the following.

C:\fakepath\WHAT I DID.odt

Thanks, Rich Ramik

edit flag offensive delete link more


Don’t think the #REF! Is correct.

You're right, after this step, everything else no longer made sense. In cells B3: B5 City 1 .City 2. City 3 should have appeared, and not an error. Hmmm... Can you try doing it on some other computer? Perhaps there is a problem with the settings of this particular computer (system, office)?

JohnSUN gravatar imageJohnSUN ( 2020-07-24 05:14:27 +0200 )edit

Will do later today. I'll post results. gravatar ( 2020-07-24 15:55:42 +0200 )edit

By the way, I'm running gravatar ( 2020-07-24 15:59:03 +0200 )edit

answered 2020-07-24 02:20:11 +0200

lazarus477 gravatar image

If you wish to link to data stored in an external file then try following these instructions: Link to External Data

edit flag offensive delete link more


This is inserting all of the cities in FILE B. I need a drop down of the cities so I am able to select the appropriate city. gravatar ( 2020-07-27 17:31:14 +0200 )edit

answered 2020-07-23 20:54:31 +0200

JohnSUN gravatar image

What's the problem? Open both files. Select file B. Select all cities and copy. Switch to file A, in an empty space, press Ctrl+Shift+V, mark Link and press OK.


Press F2 to go to cell editing, select the resulting formula and copy. Create a data validity allow cell range, in the Source paste the formula you just copied. Make sure everything works as it should and clear the inserted list of cities, it is no longer needed.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-23 20:31:31 +0200

Seen: 42 times

Last updated: Jul 24