Manual calculation mode doesn't work for tables?

[c_wag03]

I have always been under the impression that formulas, even if they are in calculated columns in a table, will not calculate if calculation mode is set to manual. However, after several cases of a workbook freezing on me today, and then testing with a very simple formula in a very small table, it appears that is not the case. Not sure if this has always been the case, but I'm on a very recent upset on Office 365. How can I stop formulas from recalculating in a table when setting calculation mode to manual doesn't work?

 

[Alex Blakenburg]

Are you appending data or replacing data ?
If you are replacing data if you are deleting the existing rows first, then I found its faster if you don't delete the rows. You can delete the content if you want but if the new data is longer even that is unnecessary.

If you are appending data, you can try copying it in leaving a blank row so the table doesn't extend, then when you ready delete the blank row and extend the table to include the new rows.
To extend the table after deleting the blank row:

ActiveCell.ListObject.Resize ActiveCell.CurrentRegion

 

[c_wag03]

Are you appending data or replacing data ?
If you are replacing data if you are deleting the existing rows first, then I found its faster if you don't delete the rows. You can delete the content if you want but if the new data is longer even that is unnecessary.

If you are appending data, you can try copying it in leaving a blank row so the table doesn't extend, then when you ready delete the blank row and extend the table to include the new rows.
To extend the table after deleting the blank row:

ActiveCell.ListObject.Resize ActiveCell.CurrentRegion

My table is loaded from power query but has several calculated formulas added to the result table. I have other tables that also reference this table with some SUMIFS and XLOOKUPS. I suspect my issue is more related to the other tables referencing it and trying to recalculate during the refresh.