ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Duncs" wrote in message ups.com...
| 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
| |
|