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
Having the same issue with my company files too. Just started randomly in the past week. We have a lot of ODBC files pulling data automatically into open excel files, with this issue the updated data does not update the table causing confusion with our users.
A fix we found was changing the external data properties from "Insert cells for new data, delete unused cells" to "insert entire rows for new data, clear unused cells". again, some of these files have been fine for years so was a bit of a guess and not sure if it will affect the files going forward.
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.
