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

Bob L

New Member
Joined
May 10, 2020
Messages
44
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
What happens if the users who are seeing the 0s click the F9 key?
Are they values updated then?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top