SOLVED

Excel 365 dynamische Arrayformeln deaktivieren

%3CLINGO-SUB%20id%3D%22lingo-sub-1485797%22%20slang%3D%22de-DE%22%3ETurn%20off%20Excel%20265%20dynamic%20array%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485797%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20Comminity%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20very%20large%20Excel%20spreadsheets%20and%20when%20I%20work%20with%20Excel%20365%20I%20found%20that%20the%20index%20formulas%20are%20stored%20as%20dynamic%20array%20formulas%20%22invisible%22.%20If%20I%20open%20the%20Excel%20file%20in%20Excel%202013%2C%20I%20will%20see%20the%20curly%20braces.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20our%20calculations%20with%20array%20formulas%20quickly%20become%2030%20to%20150%20MB%20large%20and%20can%20no%20longer%20be%20editable%2C%20I%20urgently%20need%20help%20in%20switching%20off%20this%20dynamic%20array%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3EChristian%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1485797%22%20slang%3D%22de-DE%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-1486052%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20365%20dynamische%20Arrayformeln%20deaktivieren%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486052%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20want%20the%20INDEX%20formula%20to%20work%20as%20in%20%22old%22%20Excel%2C%20add%20%40%20in%20front%20of%20it%3A%3CBR%20%2F%3E%3D%40INDEX(....)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486215%22%20slang%3D%22de-DE%22%3ERe%3A%20Disable%20Excel%20365%20dynamic%20array%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486215%22%20slang%3D%22de-DE%22%3E%3CP%3EThanks%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%2C%20that%20worked%20perfectly%20and%20saved%2020%25%20file%20size.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hallo Comminity

 

Ich arbeite an sehr grossen Excel Kalkulationstabellen und habe bei der Arbeit mit Excel 365 festgestellt, dass die Index Formeln als dynamische Arrayformeln "unsichtbar" abgespeichert werden. Öffne ich die Exceldatei in Excel 2013, so werden mir die geschweiften Klammern angezeigt.

 

Da unsere Kalkulationen mit Arrayformeln schnell 30 bis 150 MB gross und nicht mehr bearbeitbar werden benötige ich dringend Hilfe beim Abschalten dieser dynamischen Array Funktion.

 

Danke für eure Hilfe.

Christian

2 Replies
Best Response confirmed by RenTG80 (New Contributor)
Solution

If you want the INDEX formula to work as in "old" Excel, add @ in front of it:
=@INDEX(....)

Thanks@Jan Karel Pieterse, that worked perfectly and saved 20% file size.