[ms office - 2010] Excel 2010 Subtotal/Autosum

[Reaper]

Morning all

 

We recently updated the Bursars/Accounts department computers to Windows 7 and Office 2010, and unsurprisingly there are a few teething problems. Mainly with Office.

 

The accountant has previously been using pivot tables to extract data from Pass and then do her accounts. Pivot tables work mostly without a problem, the issue comes up when she wants to do totals for sections of the data, e.g

 

45

34

23

1

5

Total 108

 

12

14

10

6

7

Total 49

 

Normally to get the total for each section the accountant would select the appropriate cells and hit autosum, all nice and easy. With the newer version of Office this doesn't work the same way, what we now get is:

 

45.00

34.00

23.00

1.00

5.00

Total 108.00

 

 

216.00

171.00

137.00

114.00

113.00

Total 108.00

 

 

Because it is in a table Autosum will now use Subtotal but it picks up a funny range, if you convert the table to a normal range of cells you can do the totals without any problem. The accountant needs the data to be in a pivot table so she can refresh it directly from the database.

 

 

Has anyone encountered this?

 

 

Thanks