Do you have Tools|Calculation set for Automatic?
Brento wrote:
All,
I have written a spreadsheet with the formulas I want to use which as
'Sumproduct' but when I change the data that the sumproduct formula
reads it doesnt automaticaly update and I have the double click in the
cell and press enter then is will update?
Any ideas?
Thanks
Brent
--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=561729
--
Dave Peterson