| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
Avoid volatile Indirect problem
how about a nice looping macro
for i=1 to whatever number cells(i,2)="aaaaaaaaaa"&cells(i,1)&"bbbbbbbbbb" next -- Don Guillett SalesAid Software "teepee" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
|
Avoid volatile Indirect problem
interesting idea - shall try
"Don Guillett" wrote in message ... how about a nice looping macro for i=1 to whatever number cells(i,2)="aaaaaaaaaa"&cells(i,1)&"bbbbbbbbbb" next -- Don Guillett SalesAid Software "teepee" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Avoid volatile Indirect problem | Excel Discussion (Misc queries) | |||
| why is the INDIRECT function volatile? | Excel Worksheet Functions | |||
| How to avoid volatile hyperlinks? | Excel Programming | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
| EXCEL VBA non-volatile INDIRECT | Excel Programming | |||
![teepee[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
