Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XL 2007 Vlookup Links

Status
Not open for further replies.
Wajid55

Wajid55

Programmer
Apr 6, 2006
48
CA
Hi,

I am using XL 2007, it has Vlookup links to another XL file on a server. How do I update those links if a value is changed on the main file on the server every time I open the file?

Thanks
 
Sort by date Sort by votes
set the update links on open property to true....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Office 2000 XL
Replies
6
Views
902
dhookom
dhookom
Cpreston
  • Locked
  • Question
whats wrong with Vlookup 2
2
Replies
20
Views
635
SkipVought
S
Cpreston
  • Locked
  • Question
vlookup issue 1
Replies
4
Views
267
combo
combo
wmbb
  • Locked
  • Question
Why does VLOOKUP work and MATCH function gives #NA 1
Replies
6
Views
410
wmbb
wmbb
pjw001
  • Locked
  • Question
Problems with Office 2007 on Windows 11
Replies
16
Views
679
pjw001
pjw001

Part and Inventory Search

Sponsor

Back
Top