Forum Discussion
Insert column restricted
I have an Excel spreadsheet created and update even a year ago (July 2020) and I am trying to insert a cl=column, but with new Office 365 the message I get is "Microsoft Excel can't insert new cell...
Could you please clarify a bit what a cl=column exactly means? If something like
=N5=A:A
added to M5 that definitely doesn't work. In previous version of Excel formula compares N5 with A5 (value in current row) and returns the result. So called implicit intersection.
It doesn't work in Excel which support dynamic arrays. Excel compares entire one million values in column A with N5 and tries to return one million of resulting values starting from M5. Not enough space for that.
Above is only my guess of what do you try to do exactly.