Excel formulas replaced with values when opened by another user

Copper 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