Hi Gkirkup,
if you fix your problem with a compact db function, with an external program you can close and re-open your db.
Remember to insert the flag in access on the auto-compact db function.
Hi Preetisoft2,
with excel 2010 you have to select the table and click on the command "Insert pivot table". Done! then you cann start to play with it and show all options