Turning off Calculated Columns Excel Online

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3172561%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ETurning%20off%20Calculated%20Columns%20Excel%20Online%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3172561%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EMy%20team%20use%20an%20Excel%20table%20to%20track%20necessary%20information%2C%20however%20occasionally%20they%20will%20often%20put%20in%20a%20simple%20formula%20(usually%20in%20lieu%20of%20a%20calculator)%20that%20is%20then%20copied%20across%20the%20whole%20table%20as%20a%20calculated%20column.%20Now%20I%20know%20you%20can%20switch%20off%20calculated%20columns%20in%20Desktop%20Excel%20but%20we%20primarily%20used%20the%20document%20through%20Sharepoint%20and%20Excel%20Online%2C%20and%20there%20does%20not%20seem%20to%20be%20an%20option%20to%20switch%20it%20off.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3172561%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EExcel%20for%20web%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

Hi,

 

My team use an Excel table to track necessary information, however occasionally they will often put in a simple formula (usually in lieu of a calculator) that is then copied across the whole table as a calculated column. Now I know you can switch off calculated columns in Desktop Excel but we primarily used the document through Sharepoint and Excel Online, and there does not seem to be an option to switch it off. 

Any ideas?

0 Replies