|
|
|
| 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 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.
|
|
