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
 
Have you tried using "refresh on open" under pivot table options
 
You must log in or register to reply here.

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
Changing Database links? 3
Pivot table question 3
Pivot Table Update 3
Pivot Table Selection 2
automatically update the pivot table 1
Pivot table 1

Back
Top