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.
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.