Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel add ins

ResolvedVersion 2010

Lisa has attended:
Excel Intermediate course
Excel Advanced course

Excel Add ins

We have just changed to Microsoft Office 2010 from 2007 & was using a Morefunc add-in function called "Threed" on one of our spreadsheets. This now does not seem to be compatible with 2010, is there something else we can use?
We need figures from various sheets in a workbook on different rows (but with the same dept number) to be picked up on a summary sheet.

RE: Excel Add ins

Hi Lisa

Thanks for getting in touch. There shouldn't be any compatibility issues with Add-Ins, however you might want to check that the Add-In has been re-enabled on the 2010 installation.

Go to File > Options > Add-Ins, click Go at the bottom and ensure your Add-In is ticked. If it is not displayed in this list, you might have to browse your folders for the Add-In. After re-enabling the Add-In, restart Excel.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 26 Nov 2012: Automatically marked as resolved.

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.14 secs.