Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Updating External Data
Please Help!!! I have a function (which produces a weighted average) in each of six workbooks. In each workbook the function draws on data from the other 5 workbooks. In this way each workbook is connected to every other workbook. Since each function draws on the same data, each average should be the same but sometimes they are different. This has to do with the way the data is updated and the order in which the books are opened. Is there any way to get this data to update automatically or as data in other workbooks is changed??? I've tried to go under the edit menu and update through the links option but it refuses....thanks all. -- tillyosu ------------------------------------------------------------------------ tillyosu's Profile: http://www.excelforum.com/member.php...o&userid=25114 View this thread: http://www.excelforum.com/showthread...hreadid=386179 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import External Data | Excel Worksheet Functions | |||
External Data Source updating on open, how to turn back on prompt. | Excel Worksheet Functions | |||
Glue/Lock cells to external data before refresh | Excel Discussion (Misc queries) | |||
Import External Data | Excel Worksheet Functions | |||
parameters option on the external data toolbar is not available | Excel Discussion (Misc queries) |