Pivot Table Auto Update?

M

mkaake

I'm not too familiar with VBA, so I was wondering if there's a way tha
I can have a spreadsheet automatically update itself from a database.

Basically, I have a database in Access, and I would like to work wit
the data in Excel (as a pivot table). I would like to find a way t
have Excel automatically update the pivot table when the spreadshee
starts up. Is that do-able?

Any examples? We'll assume that the database is data.mdb and is in th
same directory as the spreadsheet.

Thanks!

mat
 
Top