Excel 2007 subtotal taking very long time RRS feed

  • Question

  • Hi,

    Excel 2007 SP2 taking very long time when using Subtotal & sometimes in Filter as well. Sometimes it ran for 3-4 HRS & user has to end task it. Even sometimes Excel hang. Event viewer showing only some warrning regarding Excel.exe. tried to create a  Excel process dump & checked with DebugDiag but not getting any clue. Kindly help to resolve this problem.


    Tuesday, February 15, 2011 7:05 AM


All replies

  • It could be that your file is corrupted - does the same thing happen on a newly-created file?
    HTH, Bernie
    Wednesday, February 16, 2011 2:04 PM
  • Thanks for your response, Bernie.

    Actually this is happening for all files on this Vista SP2 machine. this user has to take dump of data into Excel file from SAP & have to do some filter/subtotal etc. Same process is working fine on another machine in excel 2007 SP2 within 1-2 MINS but here it's taking 3-4 HRS.


    Wednesday, February 16, 2011 2:54 PM
  • It could be any of a variety of ills: try the tips located here

    HTH, Bernie
    • Marked as answer by Sally Tang Monday, February 21, 2011 6:27 AM
    Wednesday, February 16, 2011 4:12 PM