Office Software Thread, Excel 2010 Subtotal/Autosum in Technical; Morning all
We recently updated the Bursars/Accounts department computers to Windows 7 and Office 2010, and unsurprisingly there are a ...
1st February 2011, 10:46 AM #1
- Rep Power
Excel 2010 Subtotal/Autosum
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
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:
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?
IDG Tech News
By ful56_uk in forum Office Software
Last Post: 31st December 2010, 01:04 PM
By Homer in forum Windows 7
Last Post: 9th September 2010, 01:31 PM
By reecec in forum Office Software
Last Post: 28th April 2010, 09:16 PM
By Jamie_a in forum MIS Systems
Last Post: 30th January 2010, 12:25 PM
By DaveP in forum Downloads
Last Post: 22nd December 2009, 06:05 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)