I have created a spreadsheet for keeping statistics for the job. There are many sheets and many formulas that retrieve data from other sheets and many formulas with several criteria. It works just fine for me, all the formulas work. The problem is that with some colleagues the formulas will not update. The problem applies to some cells, but not all. In the cells in question, it will only say 0. With some of the colleagues, the problem cells will eventually start to update if they have the spreadsheet up for an hour or so. But only a cell here and a cell there.
Not everyone has the same language settings on the PC, so I suspect that it may have something to do with the matter, for example in sumifs formulas where date to-from is one of several criteria. But - there are other sheets in the spreadsheet that use similar formulas where it updates without a problem with my colleagues. Also sumifs with to-from date as one of several criteria that pulls data from the same sheet as the formulas I'm having trouble with. So if the language setting was a problem because of the date format, it shouldn't have worked here either.
So I don't understand what is causing this! I can share the spreadsheet if anyone wants to try to figure it out which is a mystery to me.
The first screenshot shows cells that do not update with any of my colleagues. The second screenshot shows example cells where it seems to work for everyone. Both are similar formulas with similar criteria, such as date.
Accepted Solutions