Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Smart way to concatenate into B1 all cells below until new info in Column A | Excel Discussion (Misc queries) | |||
Deleting info from all cells at once | Excel Worksheet Functions | |||
Excel-cannot view info placed in cells | Excel Discussion (Misc queries) | |||
Disappearing info in merged cells - Excel | Excel Discussion (Misc queries) | |||
Show info in linked cells in dif workbks? | Excel Worksheet Functions |