Posted to microsoft.public.excel.worksheet.functions

Shuang

external usenet poster

Posts: 2

A question about INDIRECT()

A workseet contains a lot of INDIRECT() functions, each INDIRECT() function
contains a link to another EXCEL file. Seems other EXCEL files should be
open, otherwise, reference error occurs. Because there are many other EXCEL
files, it is uncomfortable to open many EXCEL windows.

Are there any ways to use this kind of INDIRECT functions without opening
other
files?

Thanks,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
INDIRECT Question	OdAwG	Excel Discussion (Misc queries)	1	May 2nd 07 04:09 AM
INDIRECT Question I think	s boak	Excel Discussion (Misc queries)	4	May 4th 06 12:14 PM
Indirect question	saveas getting rid of formulas	Excel Discussion (Misc queries)	6	February 3rd 06 03:36 PM
indirect.ext question	Dave K	Excel Discussion (Misc queries)	0	December 14th 05 10:43 PM
INDIRECT.EXT question	SU	Excel Worksheet Functions	8	April 12th 05 07:57 PM

All times are GMT +1. The time now is 06:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us