Calculation gets slow AFTER deleting tablerows

Hello,

I'm working on a Excel file with a table (116 cols, +/-2500 rows) with automatic formulas in hidden program colums.
The calculation works smooth when changing or adding data and when filtering or adding rows.

But, once tablerows are deleted (manually or with a macro), the calcutions suddenly get and remain slow.
The time to delete the rows is not the issue. The problem is that all further operations become very slow (several seconds for simple input).
The problems only occurs after deleting tablerows, not after inserting rows. But once the calculation has slown down, it remains slow even when inserting rows.

When saving/closing the slow file and reopening it, it surprisingly just works smooth again !
This makes me believe that the structure and formulas actually are ok.

I can't find any explanation/reason for this.
The formulas don't show any errors.
I followed the standard rules and advises:
- avoiding volatile functions
- all data and formulas on same sheet
- disabling calculation, screenupdating, ... in the beginning of the macro's (and resseting at the end)
- even disabling all filters and hidden rows/columns in the beginning of the macro
I tried different methods in VBA:
- Tbl.Listrows(i).Delete
- Selection.Entirerow.Delete
- Intersect(Selection.Entirerow, Tbl.DatabodyRange).Rows.Delete
These macros all work but result in slow calculation afterwards.
Using similar programming in the macros to insert rows, does not slow down calculation !

Does anybody know this issue ? Is there a solution ?

Don't rule out the possibility that the problem originated in the workbook work layer (not accessible to us). If all formulas refer only to this worksheet try rebuilding the file:
1. create a new file
2. in the old file, copy only the range with the data and paste it into the new file. Do not copy the whole worksheet!
3. rebuild the rows height and columns width, formatting, etc.
4. copy the VBA code into the new file.

Finally, report back if there is an improvement.

Artik

Thank you Artik
That's new for me. I've been building on this file over a long time so I can imagine something got wrong.
As a first step I've deleted all (+/-2000) except one tablerow in the original file and then opened it again with restore.
I inserted and copied back in all data. That allready seems to work up to now.
When I have enough time I'll follow your advise to rebuild the entire file.

Thanks again.
Vincent