Formulas work on preliminary view but not in edition

%3CLINGO-SUB%20id%3D%22lingo-sub-1333676%22%20slang%3D%22en-US%22%3EFormulas%20work%20on%20preliminary%20view%20but%20not%20in%20edition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1333676%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20working%20in%20a%20file%20that%20a%20partner%20sent%20me%2C%20when%20I%20open%20the%20file%20%2C%20in%20preliminary%20view%20the%20formulas%20work%20on%20all%20the%20cells%20%2C%20however%20when%20I%20click%20in%20%26lt%3B%3CACTIVATE%20edition%3D%22%22%3E%26gt%3B%20the%20formulas%20stop%20to%20work%20on%20some%20cells.%20I%20dont%20know%20what%20to%20do.%26nbsp%3B%3C%2FACTIVATE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1333676%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-1335208%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20work%20on%20preliminary%20view%20but%20not%20in%20edition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335208%22%20slang%3D%22en-US%22%3EWhen%20you%20view%20the%20file%20in%20protected%20mode%2C%20Excel%20does%20not%20calculate%20but%20instead%20shows%20the%20values%20from%20the%20last%20time%20the%20file%20was%20calculated.%20If%20you%20then%20enable%20editing%2C%20Excel%20calculates.%20Apparently%20when%20you%20open%20the%20file%2C%20calculation%20results%20are%20different.%20Without%20the%20file%20it%20is%20impossible%20to%20say%20why%20that%20is.%20But%20I%20see%20that%20the%20highlighted%20cell%20contains%20the%20SI.ERROR%20function.%20apparently%20in%20all%20cells%20that%20change%20to%200%20where%20that%20function%20is%20used%2C%20the%20function%20that%20is%20supposed%20to%20return%20a%20number%20in%20reality%20causes%20an%20error%20on%20your%20system%20and%20thus%20causes%20SI.ERROR%20to%20return%200.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I was working in a file that a partner sent me, when I open the file , in preliminary view the formulas work on all the cells , however when I click in <<Activate edition>> the formulas stop to work on some cells. I dont know what to do. 

1 Reply
Highlighted
When you view the file in protected mode, Excel does not calculate but instead shows the values from the last time the file was calculated. If you then enable editing, Excel calculates. Apparently when you open the file, calculation results are different. Without the file it is impossible to say why that is. But I see that the highlighted cell contains the SI.ERROR function. apparently in all cells that change to 0 where that function is used, the function that is supposed to return a number in reality causes an error on your system and thus causes SI.ERROR to return 0.