Niek,

I've looked at the site and entered the formula. I've changed the cell
values and waited. When I enter the formula in the first row, it gives
me the correct value. When I copy it into the next row, it displays
the same value that it had in the first row. When I copy it into the
third row, it again displays the same value as rows one & two.

However, if I press F9 to refresh, the cells display the correct
values.

Is this an issue with the absence of the Analysis Toolpak, in that you
get no automatic data refresh?

Rgds

Duncs

Niek Otten wrote:
Hi Duncs,

Look he

http://www.dicks-blog.com/archives/2...-addin-part-2/

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Duncs" wrote in message ups.com...
| For one reason or another, which no one can seem to answer, we cannot
| access the "Analysis Toolpak" addin. It isn't there to install, and
| our systems guys refuse to run the setup program to make it available
| due to, "a possibility of possible system instability", or some such
| garbage reason! I've argued until I'm blue in the face, but it makes
| no difference. They wont install it.
|
| So, my next mission is to see if I can write one, or if someone else
| has written one. I need it for a spreadsheet I'm creating, and can't
| think of a way round it.
|
| So, if anyone has any ideas / suggestions / hints / tips / pointers /
| code lying around that would help me, I'd be grateful.
|
| Many thanks
|
| Duncs
|