Some formulas return 0, but not others and not for all users

[Bob L]

Hi all,

So in our month-end file, we have amounts related to actuals, budget and forecast and they are all SUMIFS formulas linked to the same tab in the same file. Some users see the actuals at 0 and the others can see the amounts just fine (the file is on SharePoint, so we're all in at the same time) and everyone can see the budget and forecast amounts which makes no sense.

There isn't any circular reference in the file and the excel options between me (who can see everything just fine) and a colleague (who sees all the actuals at 0) are the same, so no dice there.

It's a .xlsb file with a macro (SumByColor) if it could mean anything. Saving the file on desktop doesn't resolve the issue, so not SharePoint related I think.

Anyone would have any clue?

Thanks.

 

[Joe4]

What happens if the users who are seeing the 0s click the F9 key?
Are they values updated then?

 

[Bob L]

What happens if the users who are seeing the 0s click the F9 key?
Are they values updated then?

No, I should have added it to the initial post, we already tried F9, clicking in the formula bar and clicking enter on the keyboard, putting it in manual calculation and clicking in the formula bar and clicking enter on the keyboard and it always return 0 for them.