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 w...
excel
Formulas and Functions
office 365
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