Pivot Table Link

Creating a who has had what pivot table analysis

First you need to prepare your system to use odbc with MS office, depending on version of software the procedure is slightly different.  There are two things you need to do install Sage ODBC second install the MSQuery Component of MSOffice
click image for full size view

Download the Excel 2000 spreadsheet (if using Internet explorer right click and chose save target as)

When you open it you will see notes on how it works and how to do the ODBC link

If you are using Excel 97 then here (if using Internet explorer right click and chose save target as).

These sheets are provided without warranty, support or anything else, it is really for you to use as a learning tool so that you can create your own.