| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect references to an offline book
Hi everyone!
I'm trying to make references from one book to another by using the INDIRECT function, but I found out it doesn't work when the source book is not open. Making the same reference without the INDIRECT function works ok. The purpose of my application is to sum data from several books into one summary book, but the names and quantity of books can vary dynamically, so I can't include them in my formulas. Can anyone help me with this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you use INDIRECT in 3-D references? | Excel Worksheet Functions | |||
| Indirect cell references ???? | Excel Discussion (Misc queries) | |||
| Using Morefunc - Indirect.Ext when Offline | Excel Worksheet Functions | |||
| Indirect references in a linked formula | Excel Worksheet Functions | |||
| Indirect references in a linked formula | Excel Worksheet Functions | |||
Threaded Mode
