Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming

teepee[_2_] teepee[_2_] is offline

external usenet poster

Posts: 10

Avoid volatile Indirect problem

I have a cell formula in my spreadsheet

=INDIRECT("'http://www.domain.com/" &$B$2&"/[results.xls]results'!$e2")

&$B$2& rfefers to the second part of a URL which changes as B21 changes its
value

The spreadsheet functions perfectly except that it goes incredibly slowly
because INDIRECT is volatile and there are 120,000 occurences of this
formula or a variation on the same.

Anyone know a way around this or an alternative to INDIRECT that does the
same thing?

Many thanks

tp

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
why is the INDIRECT function volatile?	Dave F	Excel Worksheet Functions	2	October 25th 06 02:10 PM
INDIRECT filldown problem	Ryk	Excel Discussion (Misc queries)	2	September 28th 06 02:44 AM
Indirect problem	superkopite	Excel Discussion (Misc queries)	11	February 22nd 06 06:31 PM
INDIRECT Problem	JHarriman	Excel Discussion (Misc queries)	1	February 21st 06 03:27 PM
is there a NON-volatile version of INDIRECT ??	spiderman	Excel Discussion (Misc queries)	1	February 4th 05 04:54 PM

All times are GMT +1. The time now is 02:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us