| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Reference Data Updates.
I am using Excel 2003. I have a cell referencing an external workbook (that
is on my own computer). If the external reference is within the OFFSET or INDIRECT function, it gets a #ref error if the supporting workbook is not OPEN. When I open the supporting workbook, the same formula works fine. I tried external references that are not imbedded in functions, and they work fine (supporting workbook closed or open). I also tried the SUM function, and it too works with the supporting workbook open or closed. Am I doing something wrong? Is there some limitation that I cannot find documented? Is there a know bug? Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i reference an external workbook for data validation? | Excel Discussion (Misc queries) | |||
| Excel 2003 - Protecting Cells but allowing external data updates | Excel Worksheet Functions | |||
| Reference Data in External Workbook | Excel Worksheet Functions | |||
| cell data for external reference | Excel Worksheet Functions | |||
| External Data Updates | Excel Programming | |||
Threaded Mode
