Consulting

Results 1 to 4 of 4

Thread: Excel keeps calculating - Table:1, 2...

  1. #1

    Excel keeps calculating - Table:1, 2...

    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.
    Attached Files Attached Files

  2. #2
    VBAX Expert CatDaddy's Avatar
    Joined
    Jun 2011
    Posts
    581
    Location
    in visual basic editor check the "ThisWorkbook" object for workbook event codes
    ------------------------------------------------
    Happy Coding my friends

  3. #3
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    Do you have data tables set up in that workbook?
    Be as you wish to seem

  4. #4
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •