#1   Report Post  
Old June 4th 12, 09:33 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2012
Posts: 1
Default updating problem

Hi there,

I have an on going problem with updating data from linked excel files.

1. I'm working with excel 2010.
2. The source files are excel 2007.
3. The link formula is VLOOKUP, for example:
=VLOOKUP(A3,'C:\mobiledep\marketing\Documents\[output (1).xls]Sheet1'!$A:$B,2,0)
4. The data from the source files is not updated
a. I need to open the source file.
b. In some cases it helps, in other, the data still not updated, even when the source file is open.
c. I drag the formula down the relevant rows – in some cases it helps – in other only part of the data is updated.
d. When dragging the formula down the relevant rows – a window with the file location is popping out, and I need to select the file – but in some cases it does not help.
e. In some cases I need to re-Wright the vlookup formula – and only after that – the data is updated.
5. I have about 60 deferent files linked to my master file (the file that holds all the links).
6. Also – having a similar problem with a pivot table – if the source file is not open – the data will not be updated when refreshing the pivot.
All the option in the trust center are enabled or with prompt option (as far as I can tell – but maybe there are options that I’m not aware of).
What should I do so the data will be updated in my master file when changes are being done in the source file – without having to open all the 60 file and/or re-typing the vlookup formulas?

Hhhhhhhhelp……

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Updating Links Delos Excel Programming 3 March 22nd 07 11:09 AM
Problem with formulas updating Cathy W[_2_] Excel Programming 10 December 19th 05 06:10 PM
updating one spreadsheet with another problem davidbev008 Excel Worksheet Functions 1 October 1st 05 02:50 AM
problem updating cells ties[_2_] Excel Programming 3 August 25th 04 02:14 PM
Updating worksheet problem HamishM[_4_] Excel Programming 2 December 20th 03 04:25 AM


All times are GMT +1. The time now is 09:26 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017