Pivot Table Auto Update?

  • Thread starter Thread starter mkaake
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
pivot tables 1
Pivot table question 3
Pivot Table Selection 2
Changing Database links? 3
automatically update the pivot table 1
Pivot Table Update 3
Pivot table 1

Back
Top