| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Cells not updated automatically
I have a formulas that doesnt automatically compute the formula there is a change in one of the input.
There are 3 tabs, A, B, C 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 in tab A doesnt automatically get updated. I search in the internet and someone mentioned that this could be due to the fact that tab A doesnt know that they need to recomputed when there is a change in tab C. Anyone know how to make tab A re-compute the data when there is a change 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 a change in tab C? Updates: I realised that if I do a Ctrl + Alt + Shift + F9, the cells will be updated. However, is there any thing I can do to make it auto-updates without the need to manually refresh the table? Many thanks for the assistance. Last edited by CS Chia : March 5th 14 at 06:27 AM |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cells not updated automatically
Uh.., is Calculation set to 'Automatic' in the Options 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 |
|
#3
|
|||
|
|||
|
Quote:
This is the formula: =SUMPRODUCT(--('Tab B'!$C$3:$C$3010='Tab A'!$A$4),--('Tab B'!$D$3:$D$3010='Tab A'!$B$4),--('Tab B'!$E$3:$E$3010="YES"),('Tab B'!M$3:M$3010)) It was working when the formula is this: =SUMPRODUCT(--('Tab B'!$C$3:$C$3010='Tab A'!$A$4),--('Tab 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, 'Tab C'!$B$6:$B$36,0),3)), "") The moment this --('Tab B'!$E$3:$E$3010="YES") is added, the formulas doesnt automate update when there is a change in tab C. Please help. Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cells not updated automatically
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tie additional cells to cell automatically updated | Excel Discussion (Misc queries) | |||
| automatically insert autoshapes when cells are updated? | Excel Discussion (Misc queries) | |||
| Automatically insert time in excel but not automatically updated | Excel Worksheet Functions | |||
| Excel cells randomly don't get updated unless each cell is updated | Excel Discussion (Misc queries) | |||
| The content of my cells (formulas) isn't updated automatically any | New Users to Excel | |||
Hybrid Mode
