Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Workbook References and Functions
I have Excel spreadsheet A. When I simply reference another cell in Excel
spreadsheet B (a separate file) to spreadsheet A, I don't need spreadsheet B open to see the value in A. However, when I include the external reference from B in any sort of a function in A, when I have A open without B open, I get the "values" error in A. My hypothesis here is that one cannot use external cell references in functions. Is this correct? Or does someone know a way around this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
External Workbook References and Functions
It depends upon the function. Most will work on a closed workbook, but some
don't (like INDIRECT). What are you trying to use? HTH, Elkar "JMSatMetro" wrote: I have Excel spreadsheet A. When I simply reference another cell in Excel spreadsheet B (a separate file) to spreadsheet A, I don't need spreadsheet B open to see the value in A. However, when I include the external reference from B in any sort of a function in A, when I have A open without B open, I get the "values" error in A. My hypothesis here is that one cannot use external cell references in functions. Is this correct? Or does someone know a way around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET and external workbook references | Excel Discussion (Misc queries) | |||
External References in Functions | Excel Worksheet Functions | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
External References | Excel Discussion (Misc queries) | |||
How do you locate External References in an Excel Workbook | Excel Discussion (Misc queries) |