Shared excel not showing formula calculations for some users

%3CLINGO-SUB%20id%3D%22lingo-sub-2083411%22%20slang%3D%22en-US%22%3EShared%20excel%20not%20showing%20formula%20calculations%20for%20some%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2083411%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20shared%20excel%20with%20several%20tables%20that%20use%20formulas%20to%20show%20results.%20When%20I%20open%20the%20file%20I%20can%20see%20the%20formula%20calculations%20working%20correctly%20but%20some%20of%20my%20colleagues%20cannot.%3C%2FP%3E%0A%3CP%3EThis%20is%20what%20I%20see%20when%20I%20open%20the%20file%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Laura1818_1-1611250567202.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248111iE6C124CB7EA0C32C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Laura1818_1-1611250567202.png%22%20alt%3D%22Laura1818_1-1611250567202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EBut%20some%20of%20my%20colleagues%20cannot%20see%20the%20formula%20results%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Laura1818_2-1611250658162.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F248113i729F71FA83152B72%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Laura1818_2-1611250658162.png%22%20alt%3D%22Laura1818_2-1611250658162.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20someone%20please%20help%20me%20with%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2083411%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2083694%22%20slang%3D%22en-US%22%3ERe%3A%20Shared%20excel%20not%20showing%20formula%20calculations%20for%20some%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2083694%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F937907%22%20target%3D%22_blank%22%3E%40Laura1818%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20hypothesis%20would%20be%20that%20there%20are%20links%20in%20the%20formulas%20to%20other%20workbooks%20that%20you%20have%20access%20to%20but%20your%20colleagues%20don't.%20Is%20that%20the%20case%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%2C%20without%20disclosing%20proprietary%20information%2C%20for%20you%20to%20post%20a%20copy%20of%20the%20spreadsheet(s)%20in%20question%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2085925%22%20slang%3D%22en-US%22%3ERe%3A%20Shared%20excel%20not%20showing%20formula%20calculations%20for%20some%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2085925%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAll%20the%20links%20reference%20a%20table%20in%20the%20same%20workbook%20but%20different%20worksheet.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat's%20happening%20is%20very%20strange%20because%20it%20does%20not%20happen%20always%2C%20sometimes%20he%20can%20see%20the%20formula%20results%20displaying%20properly.%20Sometimes%20he%20needs%20to%20filter%20the%20source%20table%20and%20sometimes%20results%20are%20not%20displaying%2C%20no%20matter%20what.%3C%2FP%3E%0A%3CP%3EI'm%20asking%20if%20I%20can%20display%20the%20spreadsheet%2C%20as%20it's%20work%20related.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

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:

Laura1818_1-1611250567202.png

But some of my colleagues cannot see the formula results:

Laura1818_2-1611250658162.png

 

Can someone please help me with this?

 

 

2 Replies

@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?

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.