Getting Rid of Data Tables

[jennifuh]

Hi there,

I have a spreadsheet that takes forever to save as it cycles through data tables.

Bottom says:
SAVING - DATA TABLE: 1 (goes all the way to 6 eventually)

I didn't create any data tables nor is it in the name manager so I don't know how to get rid of them.

Thanks,
Jenny

 

[hennahairgel]

It sounds like it may have a Workbook.BeforeSave Event: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/workbook-beforesave-event-excel

 

[jennifuh]

Sorry it actually says CALCULATE on the left and DATA TABLE: X on the right.

It's recalculating the whole spreadsheet before saving. But it shouldn't take this long.. it's just one sheet with 20x40 cells.

If that is the case, how do I fix it?