Cells not updated automatically


C

CS Chia

I have a formulas that doesnt automatically compute the formula there i
a change in one of the input

There are 3 tabs, A, B,

A is the tab which has the SUMPRODUCT formulas
This formulas reference to data in tab B

Tab B has a column which takes data from Tab C to generate an output
This output will be used by tab A

I realised that if I update the information in tab C, there formulas i
tab A doesnt automatically get updated

I search in the internet and someone mentioned that this could be due t
the fact that tab A doesnt know that they need to recomputed when ther
is a change in tab C

Anyone know how to make tab A re-compute the data when there is a chang
in tab C

I have attached the sample mentioned here in this tread
The sample is working but not at my actual excel

Not sure why is it not working in my actual cell
Any way to push the formulas in tab A to auto-update when there is
change in tab C

Updates
I realised that if I do a Ctrl + Alt + Shift + F9, the cells will b
updated
However, is there any thing I can do to make it auto-updates without th
need to manually refresh the table

Many thanks for the assistance

+-------------------------------------------------------------------
|Filename: sample.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=947
+-------------------------------------------------------------------
 
Ad

Advertisements

C

CS Chia

'GS[_2_ said:
;1616533']Uh.., is Calculation set to 'Automatic' in the Option
dialog?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Yes, it is set to automatic

This is the formula:
=SUMPRODUCT(--('Tab B'!$C$3:$C$3010='Tab A'!$A$4),--('Ta
B'!$D$3:$D$3010='Tab A'!$B$4),--('Tab B'!$E$3:$E$3010="YES"),('Ta
B'!M$3:M$3010))

It was working when the formula is this:
=SUMPRODUCT(--('Tab B'!$C$3:$C$3010='Tab A'!$A$4),--('Ta
B'!$D$3:$D$3010='Tab A'!$B$4),('Tab B'!M$3:M$3010))

--('Tab B'!$E$3:$E$3010="YES") was not there.

In tab B, the column E has a formula
=IFERROR(UPPER(INDEX('Tab C'!$B$6:$D$36,MATCH('Tab B'!$B4, 'Ta
C'!$B$6:$B$36,0),3)), "")


The moment this --('Tab B'!$E$3:$E$3010="YES") is added, the formula
doesnt automate update when there is a change in tab C.


Please help.
Thanks

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
Ad

Advertisements

G

GS

Sorry, I'm not familiar enough with SUMPRODUCT to competantly offer any
suggestions! Hopefully someone else with jump in...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top