Forum Discussion
Excel does not allow me to insert rows (and when it does, its armageddon)
Hi all. I may have found out a way around this problem. If you change the workbook calculations to manual, it allows you to insert cells and the file does not mess with the formulas. Not sure for how long it will work, but at least you are allow to edit the models while somebody (hopefully) fix the issue
Hi all. I may have found out a way around this problem. If you change the workbook calculations to manual, it allows you to insert cells and the file does not mess with the formulas. Not sure for how long it will work, but at least you are allow to edit the models while somebody (hopefully) fix the issue
I have exactly the same issue on one complex XLS. Been happening on and off for a couple of months, and none of the fixes work. Even if I create a new blank tab it still doesn't let me insert rows or columns.
Just installed the latest office updates, but no joy.
Be interested to hear if anyone ever finds a fix!
Did you ever find a real permanent fix to your issue? I just posted a reply to the original post as I am experiencing the same problem all of a sudden. Please excuse that I'm pinging everyone who posted here to see if anyone came to any sort of permanent fix.
