Updating Cells with new info
 

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

Updating Cells with new info
 

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

Updating Cells with new info
 

That should be Tools|Options|Calculation tab.

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

Updating Cells with new info
 

this may be due to manual calculation checked

go to tools options calculation tab check automatic

that should work

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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=561729

Updating Cells with new info
 

All,

Thanks for the info.

I have checked that and it was already set to automatic?

Any other ideas?

Brento


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=561729

Updating Cells with new info
 

Maybe....

Select all the cells in that worksheet
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Then test it out to see if that change all woke up excel.

Brento wrote:

All,

Thanks for the info.

I have checked that and it was already set to automatic?

Any other ideas?

Brento

--
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

Updating Cells with new info
 

Thanks for the advice but still the same problem.

It works for most but I still have th double click in some cells and
then enter to update?

This is the first time it has ever happened to me?

thanks


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=561729

Updating Cells with new info
 

I don't have another guess.

Sorry.

Brento wrote:

Thanks for the advice but still the same problem.

It works for most but I still have th double click in some cells and
then enter to update?

This is the first time it has ever happened to me?

thanks

--
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