Excel XP Subtotaling Problem

  [DELETED] 09:54 17 Sep 2003

Dear All,

When I have a few excel sheets open and I try to subtotal one of them, on occasions excel seems to freeze up and become non responsive. When I exit excel and save changes to my sheet I find the subtotals have been added anyway.
The easiest way to replicate the problem is to open a worksheet, enter any value an cell A1,save as book1.xls, then open a new workbook and link to that one cell in book1, save this new workbook as book2.xls and close both sheets. Now open a third workbook, An Cells A1:A2 enter the value "A", in A3:A4 enter the value "B" and in A5:A6 enter the value "C", then in column B enter random values relating to those references. Now close the worksheet and excel saving the third workbook as book3.xls.
Finally open excel first and set calculation to manual, then open book 2 and book 3 together, select book 3 and the do subtotals, at each change in A, Use function Sum and add to B.

Any help would be appreciated.

  [DELETED] 18:33 17 Sep 2003

When it seems to freeze, press ESC.

  [DELETED] 21:42 17 Sep 2003

Escape doesn't work, you have to close excel.

  [DELETED] 22:02 17 Sep 2003

If it is Excel 2000 or 2002 (XP) try Help/Detect and repair.

  [DELETED] 22:23 18 Sep 2003

Still no joy, have tried on different pc's with the same problem, have also applied the latest patches and Microsoft say they cannot replicate the problem!

  [DELETED] 08:54 27 May 2004

Never was able to resolve problem, found some 'workarounds' though. By switching to 'Full screen' and then back Excel reverted to normal. Another way was to change the calculation from auto to manual and vice verca.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

How to watch the World Cup for free on TV and online

16 illustration tips for packaging

Best external graphics cards (eGPUs) for Mac

Les meilleurs antivirus pour Mac (2018)