| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Does file need to be open for INDIRECT to another workbook to work
That's the question. I am using indirect references to lookup from another
workbook. It seems as though the files must be open. Is there any way around this without using script. |
|
#2
|
|||
|
|||
|
Hi
yes it has to be open. For workarounds see: http://www.dicks-blog.com/archives/2...oks/trackback/ -- Regards Frank Kabel Frankfurt, Germany briancrosier wrote: That's the question. I am using indirect references to lookup from another workbook. It seems as though the files must be open. Is there any way around this without using script. |
|
#3
|
|||
|
|||
|
Thank you. That was an excellent referral.
"Frank Kabel" wrote: Hi yes it has to be open. For workarounds see: http://www.dicks-blog.com/archives/2...oks/trackback/ -- Regards Frank Kabel Frankfurt, Germany briancrosier wrote: That's the question. I am using indirect references to lookup from another workbook. It seems as though the files must be open. Is there any way around this without using script. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I open a shared xls workbook on a PC and Mac at the same ti | Excel Discussion (Misc queries) | |||
| Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
| format question when open csv file | Excel Discussion (Misc queries) | |||
| When I select "Open" from the "File" menu in Excel, I get only a . | Excel Discussion (Misc queries) | |||
| Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) | |||
Hybrid Mode
