Excel performance issues - non response for no reason RRS feed

  • Question

  • Performance issues:

    I have workbooks  with

    • worksheets with dataset that have data only

      worksheets with dataset that have data that run analysis  (they don't have issues)

      worksheets that calculate but nothing extensive.  (they don't have issues)

    The macros don't take long, however there are other issues.  I'll just touch a worksheet and it goes into non-response for no reason.  It isn't saving and is unavailable for up to several minutes.  These worksheets have no calculations.  They use about 700 rows of data from the A to GL columns.  There are a lot of formatted cells.


    Wednesday, September 10, 2014 10:16 PM

All replies

  • I don't think it's possible to guess what the problem is here... This question is way too broad for anyone to answer and the number of solutions possible is pretty much endless. 

    If you are not willing to share the workbook we can't really offer any help...

    Thursday, September 11, 2014 9:27 AM
  • I'll encrypt and share the workbook but I don't think that will do any good for troubleshooting.

    I think I'll contact MS and pay the one time support fee.

    Thank you,


    Thursday, September 11, 2014 3:13 PM
  • Set the calculation mode to Manual.

    If it still "hangs up", I would close it, and re-open it and do an "Open and Repair" operation on it.

    Friday, September 12, 2014 10:53 PM