Excel formulas replaced with values when opened by another user

%3CLINGO-SUB%20id%3D%22lingo-sub-1431497%22%20slang%3D%22en-US%22%3EExcel%20formulas%20replaced%20with%20values%20when%20opened%20by%20another%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431497%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20problems%20with%20an%20excel%20file%20I%20created.%20When%20I%20send%20the%20file%20to%20another%20user%20and%20they%20open%20it%20the%20formulas%20are%20replaced%20with%20values.%20How%20can%20I%20fix%20this%3F%20Is%20it%20a%20compatibility%20issue%20on%20the%20receivers%20side%3F%20If%20so%2C%20how%20can%20I%20determine%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%20a%20screenshot%20of%20the%20version%20I%20sent%20with%20the%20formulas%20(as%20sent.jpg)%20and%20a%20screenshot%20of%20the%20file%20as%20received%20by%20the%20intended%20user%20with%20the%20formula%20converted%20to%20a%20value%20(as%20received.jpg).%26nbsp%3B%20Both%20screenshots%20were%20take%20in%20the%20Show%20Formulas%20function%20of%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1431497%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433331%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formulas%20replaced%20with%20values%20when%20opened%20by%20another%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433331%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20thoughts%20at%20all%3F%3F%3F%3F%3F%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685741%22%20target%3D%22_blank%22%3E%40ChristineDiorio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm having problems with an excel file I created. When I send the file to another user and they open it the formulas are replaced with values. How can I fix this? Is it a compatibility issue on the receivers side? If so, how can I determine? 

I've attached a screenshot of the version I sent with the formulas (as sent.jpg) and a screenshot of the file as received by the intended user with the formula converted to a value (as received.jpg).  Both screenshots were take in the Show Formulas function of Excel.

1 Reply
Highlighted