refresh pivot table automatically from form

  • Thread starter Nathalie Hildesheim
  • Start date
N

Nathalie Hildesheim

I,ve made a form with a pivot table which can be edited
in excel. I've tried to refresh the pivot table
automatically in excel but it doesn't work when it is
linked in the form. There is an option in excel to
refresh when opening the document but I can only refresh
by clicking the red "!" button when excel is already
opened.

How can I refresh the pivot table in the form
automatically?
 
N

Nathalie Hildesheim

Just found out! It doesn't work in Office 2000, in Office
XP it does work!
 

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

Excel does not accept text format! 0
Pivot table report invalid 0
Pivot table refresh. 0
Embed the same Excel multiple times 0
Turning off automatic calculation 0
Linked sheets combined with pivot tables in Access - how to refre 0
pivot table missing rows? 0
Pivot table in forms 0

Top