Forum Discussion

Laura1818's avatar
Laura1818
Icon for Microsoft rankMicrosoft
Jan 21, 2021

Shared excel not showing formula calculations for some users

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?

 

 

excel
Formulas and Functions
office 365

2 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    Jan 21, 2021

    Laura1818 

     

    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?

    • Laura1818's avatar
      Laura1818
      Icon for Microsoft rankMicrosoft
      Jan 22, 2021

      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. 

Resources