A Conversation for Ask h2g2
Excel
spebchob Started conversation Oct 25, 2000
I want to use the INDIRECT function to reference to other workbooks without having them open, but this returns REF! error. Is there another way round this? I am trying to concatenate other cells with the filenames and addresses to create a cell reference to other workbooks.
RTM
Is mise Duncan Posted Oct 25, 2000
Remarks
========
ยท If ref_text refers to another workbook (an external reference), the other workbook must be open. If the source workbook is not open, INDIRECT returns the #REF! error value.
At least, that's what the annoying little paperclip fellow says 
<>====uuu====<
Clip-it must die!!!!!
The Jester (P. S. of Village Idiots, Muse of Comedians, Keeper of Jokes, Chef and Seraph of Bad Jokes) LUG @ A458228 Posted Oct 26, 2000
If I find out how to, I'll write a plug-in for Office so you can terminate him with extreme prejudice
3
JOTD: You possess a mind not merely twisted, but actually sprained.
Clip-it must die!!!!!
The Jester (P. S. of Village Idiots, Muse of Comedians, Keeper of Jokes, Chef and Seraph of Bad Jokes) LUG @ A458228 Posted Nov 7, 2000
No I haven't. Where might I find it?!?
3
JOTD: For a REAL sponge cake, BORROW all the ingredients
Key: Complain about this post
Excel
- 1: spebchob (Oct 25, 2000)
- 2: Is mise Duncan (Oct 25, 2000)
- 3: The Jester (P. S. of Village Idiots, Muse of Comedians, Keeper of Jokes, Chef and Seraph of Bad Jokes) LUG @ A458228 (Oct 26, 2000)
- 4: Dinsdale Piranha (Oct 27, 2000)
- 5: The Jester (P. S. of Village Idiots, Muse of Comedians, Keeper of Jokes, Chef and Seraph of Bad Jokes) LUG @ A458228 (Nov 7, 2000)
More Conversations for Ask h2g2
Write an Entry
"The Hitchhiker's Guide to the Galaxy is a wholly remarkable book. It has been compiled and recompiled many times and under many different editorships. It contains contributions from countless numbers of travellers and researchers."