Excel: Cannot disable auto calculate column on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2701133%22%20slang%3D%22en-US%22%3EExcel%3A%20Cannot%20disable%20auto%20calculate%20column%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2701133%22%20slang%3D%22en-US%22%3E%3CP%3ENothing%20in%20options%2C%20no%20macros%20%2F%20VBA%20nor%20'undo'%20last%20steps%20allow%20me%20to%20disable%20auto%20calculate%20columns%20in%20a%20particular%20excel%20sheet%20in%20excel%20Mac%20v16.52.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20sheet%20table%20it%20being%20automatically%20filled%20and%20the%20column%20is%20formatted%20like%3A%3C%2FP%3E%3CP%3EHYPERLINK(%22%3CA%20href%3D%22http%3A%2F%2Fblahblah.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fblahblah.com%3C%2FA%3E%22%2C%22the%20link%22).%3C%2FP%3E%3CP%3ENaturally%20these%20must%20be%20unique%20for%20each%20entry%20but%20instead%20each%20entry%20is%20identical%20to%20the%20first...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attempted%20to%20open%20in%20Windows%20excel%20and%20de-select%20all%20relevant%20options.%20But%20it%20still%20auto-fills....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2701133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Nothing in options, no macros / VBA nor 'undo' last steps allow me to disable auto calculate columns in a particular excel sheet in excel Mac v16.52.

 

My sheet table it being automatically filled and the column is formatted as:

=HYPERLINK("http://blahblah.com","the link").

Naturally these must be unique for each entry but instead each entry is identical to the first...

 

I've attempted to open in Windows excel and de-select all relevant options. But it still auto-fills, both when used in Win environment and Mac environment.

 

1 Reply

@LachlanH2U 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.