Jan 21 2021 09:40 AM
I created a shared excel with several tables that use formulas to show results. When I open the file I can see the formula calculations working correctly but some of my colleagues cannot.
This is what I see when I open the file:
But some of my colleagues cannot see the formula results:
Can someone please help me with this?
Jan 21 2021 10:27 AM
One hypothesis would be that there are links in the formulas to other workbooks that you have access to but your colleagues don't. Is that the case?
Is it possible, without disclosing proprietary information, for you to post a copy of the spreadsheet(s) in question?
Jan 22 2021 12:08 AM
Thanks @mathetes!
All the links reference a table in the same workbook but different worksheet.
What's happening is very strange because it does not happen always, sometimes he can see the formula results displaying properly. Sometimes he needs to filter the source table and sometimes results are not displaying, no matter what.
I'm asking if I can display the spreadsheet, as it's work related.