|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
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:
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 Im 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?
|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|