Excrutiatingly slow insert/delete times using table and defined names

[HMSTPI]

I have a file that is taking longer and longer to insert/delete/move cells/columns/rows now up to at least 10 minutes EVERY SINGLE TIME! I have tried absolutely EVERYTHING that I can find and am at my wits end.

I started from scratch to create a budget model that would provide forecasting options without the need to worry about formula inconsistency and, really, have everything working like I want -- except this one MAJOR issue.

The file is really quite simple at this point as I am still flushing out all of the forecasting options:​

only 3 data sheets
almost everything is in table format
about 200 defined names; about 1/2 are just cell references, the rest using if, sumif, index, match, indirect and offset functions
the longest table is only 350 rows -- and not all formulas​

There are NO:​

references to entire columns or rows
no conditional formats
no external connections
no shapes or images​

Here is what I have tried:​

recreating the file / copying data over to new file
deleted data validations
made everything the same font / removed bold, italics, shading, and borders
removed add-in and the formulas that used it
turned off unneeded background programs
saved the file locally
rebooted the computer
saved the file as .xslb
​

Absolutely NOTHING has worked-- in fact it just seems to get worse every time I try another insert/delete. I am on Windows 7, Excel 2016 64-bit with 2G memory and 118GB free space on C:. The Resource Monitor shows that, when acting on the delete/insert, only 12% CPU and 31% memory is in use.

I'm praying you can give me more ideas.

Thanks so much!

 

[MARK858]

FWIW, It wouldn't open for me.

Opened for me but haven't had a chance to look at it yet, maybe you can open the copy in the link below.

https://app.box.com/s/cnl9c6ubvwtu1n4law3x0piwvzbzundq