Cells in excel not automatically updating
Unfortunately, if you set it to manual and forget about it, your formulas will not recalculate.
Select the cell that is not recalculating and, on the Home ribbon, check the number format. When a cell is formatted as Text, Excel makes no attempt to interpret the contents as a formula.
One worksheet is called the source worksheet, from where this link pulls the data automatically, and the other worksheet is called the destination worksheet that contains that link formula and where data is updated automatically.
Remember one thing that formatting of cells of source worksheet and destination worksheet should be the same otherwise the result could be viewed differently and can lead to confusion.
In Excel, copying data from one worksheet to another is an easy task, but there is not any link between the two.
Note: If you format a cell as General and you discover that Excel is changing it automatically to text, try setting it to Number.
Color (or any cell format) is just not a very effective means to flag cells for counting. What is the reason that a cell would be colored or not colored in the first place?
Whatever criteria you use in your head to choose whether a cell is colored or not can probably be used as a criteria in a countif(s) type of function. I reread the part about putting the code "on the right worksheet module" and after trying all permutations, found one that did the trick.
When a cell formatted as General and the cell contains a reference to another cell, Excel copies the format of the referenced cell.
Choosing any format other than General will prevent Excel from changing the format.