file from Excel 2016 opened with 2010

[thoandros]

Hello folks
I am going crazy with this file that I am trying to use on another computer that has still Excel 2010 on it.
Now, I know some formulas were not yet created (for example I changed all IFNA into IFERROR) etc but the problem I am getting is even worst.
Basically some cells are not updating but some others are.

The file has auto calculation disabled as I have some macros that control calculations and can't have it automatic. However before launching macros, I can update some cells and press F9 for all dependant cells to change accordingly. With 2016.

With the same file, using Excel 2010 I have a bizarre behaviour

Example.

Sheet2 B6: GAMMA
Sheet2 B7: OMEGA

When I change value of cell B3, B6 and B7 change due to a VLOOKUP formula into

Sheet2 B6: ALFA
Sheet2 B7: BETA


So far all good.

But when I go in Sheet1 i have the following


CZ6: =Sheet2!B6 (and shows correctly ALFA)
CZ7: =Sheet2!B7 (and shows correctly BETA)

DN6 =CZ6 (and shows correctly ALFA)
DN7 = CZ7 (and shows correctly BETA)

EF6 =CZ6 (and still shows GAMMA)
EF7 = CZ7 (and still shows OMEGA)


how is it possible that two cells containing the very same formula (=CZ6) one is updating correctly and the other not?


I tried to press Ctrl Alt F9 and all values become correct. However I don't know why I have to do this? If I have to do it, then how would I change the "Calculate" in the vba code to replicate this?

Also, in the vba code at some point I have a calculate only for one specific sheet because other formulas in another sheet should not change.


If someone can illuminate me on that, would be great. Unfortunately searching the web and forums is not bringing me light.

Thank you very much

[teylyn]

The point of manual calculation is that cells will not automatically update. If you can't have calculation set to automatic, then you will need to trigger recalculation manually.

You can trigger a calculation of just the current sheet by using the ribbon command Calculate Sheet or Shift + F9. That way you don't have to select each cell and recalc only the cell.

In VBA you can use

Please Login or Register  to view this content.

to recalculate just a specific sheet or a specific range respectively.

[thoandros]

Thank you, but the reason why only some cells update and some (with the very same formula) don’t is still unclear.