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.
