Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling data from another workbook
I need to find out how to have Workbook A update automatically when opened
with data from Workbook B. At this point when i open Workbook A it currently asks if i would like for it to update and if i click yes, it doesn't update it changes all my formulas to #VALUE. But if i go open Workbook B myself, Workbook A corrects itself. How can i fix this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling data from another workbook
What are the formulae like that you use to access the data? Some
functions do not work with closed workbooks. Pete On Nov 18, 2:45*pm, Frustrated wrote: I need to find out how to have Workbook A update automatically when opened with data from Workbook B. *At this point when i open Workbook A it currently asks if i would like for it to update and if i click yes, it doesn't update it changes all my formulas to #VALUE. *But if i go open Workbook B myself, Workbook A corrects itself. *How can i fix this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling data from another workbook
Some functions, such as INDIRECT and SUMIF, need the linked workbooks open to
return a value. If your links are in formulas with this limitation, that would cause the #VALUE error if the linked workbooks aren't also open. SUMIF can be replaced with SUMPRODUCT, which does work with closed workbooks. Without knowing the nature of your links (which formulas are using them), it's hard to give specific advice. Hope this helps, Hutch "Frustrated" wrote: I need to find out how to have Workbook A update automatically when opened with data from Workbook B. At this point when i open Workbook A it currently asks if i would like for it to update and if i click yes, it doesn't update it changes all my formulas to #VALUE. But if i go open Workbook B myself, Workbook A corrects itself. How can i fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from Sheets in A workbook | Excel Worksheet Functions | |||
pulling data from one workbook to another based on a condition | Excel Worksheet Functions | |||
Help Required: Pulling data from a workbook into a worksheet. | Excel Worksheet Functions | |||
pulling through data from another workbook | Excel Discussion (Misc queries) | |||
Pulling data from another workbook | Excel Worksheet Functions |