Excrutiatingly slow insert/delete times using table and defined names

HMSTPI

New Member
Joined
Jul 31, 2017
Messages
18
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!
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top