Excel XP Subtotal method not working

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

We have a workbook that was created in Office 2000 that contains a
macro that performs subtotals on a range. We have several machines in
our company that are running Office XP (various OS) and are having
problems with this workbook/macro. In Office XP, the subtotal method
does not work. Before adding code to the macro to stop screen
updating, the spreadsheet would lock up. Now this doesn't happen but
the subtotal function is not working properly. This happens on each
Office XP machine.

Thanks in advance.
Stephanie
 
I had the same problem with my macros when i transfer them from excel t
XP. All you have to do is set your excel sheets to automati
calculations go to Tools>Options>Calculations and check aut
calculation. Also, make sure that your VB formula doesn't have it se
to the Manuel.
Let me know if this works:
 
Back
Top