Excel does not read/activate formulas sent via outlook unless I open the file and save it

%3CLINGO-SUB%20id%3D%22lingo-sub-1827676%22%20slang%3D%22en-US%22%3EExcel%20does%20not%20read%2Factivate%20formulas%20sent%20via%20outlook%20unless%20I%20open%20the%20file%20and%20save%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1827676%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3EOur%20organization%20has%20built%20a%20process%20where%20we%20get%20excel%20files%20with%20information%20to%20then%20use%20in%20an%20API%20program.%20The%20problem%20is%20that%20these%20formulas%20in%20the%20excel%20file%20that%20is%20sent%2C%20are%20not%20%22activated%22%20in%20the%20other%20sheets%20until%20I%20open%20the%20excel%20file%2C%20activate%20editing%20and%20save%20it.%20I%20have%20also%20turned%20off%20%2F%20unchecked%20these%20security%20checks%20that%20are%20on%20the%20security%20center%20in%20%22protected%20view%22.%20The%20difference%20is%20that%20%22edit%20file%22%20does%20not%20appear%2C%20but%20the%20formulas%20still%20do%20not%20work%20unless%20I%20save%20the%20excel%20file.%20How%20can%20I%20get%20the%20formulas%20in%20an%20excel%20file%20to%20work%2C%20when%20sent%20via%20outlook%20without%20having%20to%20open%20it%20and%20save%20it%3F%3F%3F%20Why%20is%20it%20like%20this%3F%3F%20Please%20help.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1827676%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
Highlighted
Occasional Visitor

Hello,

Our organization has built a process where we get excel files with information to then use in an API program. The problem is that these formulas in the excel file that is sent, are not "activated" in the other sheets until I open the excel file, activate editing and save it. I have also turned off / unchecked these security checks that are on the security center in "protected view". The difference is that "edit file" does not appear, but the formulas still do not work unless I save the excel file. How can I get the formulas in an excel file to work, when sent via outlook without having to open it and save it??? Why is it like this?? Please help.

0 Replies