PDA

View Full Version : Excel keeps calculating - Table:1, 2...



musicgold
10-06-2011, 01:29 PM
Hi,

My Excel is behaving strangely when I open a particular file. Every so often, it kind of freezes momentarily. It actually does some kind of calculation. Please see the attached screenshots. When it freezes, in the bottom left corner of Excel I can see Table: 1 or Table:2 and so on. I am not sure what is going on.
Any idea why this is happening?

Thank you.

CatDaddy
10-06-2011, 04:20 PM
in visual basic editor check the "ThisWorkbook" object for workbook event codes

Aflatoon
10-07-2011, 01:05 AM
Do you have data tables set up in that workbook?

musicgold
10-07-2011, 05:43 AM
Thanks folks.


Do you have data tables set up in that workbook?
Yes. You pointed me in the right direction. I changed the calculation setting to 'automatic except tables' and it is working faster now. Is there anything else that needs to be done?

Also there was no code in the workbook events.

Thanks.