MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto-Refreshing Pivot-tables


Posted by Darryl on January 21, 2002 8:48 AM

I was wondering if someone could help me. The option, in the Pivot table says "refresh every ___ minutes" with a checkbox. However, it is greyed out and I can't select it. Help was no help and I didn't see the answer in the archives.


Posted by Chris D on January 21, 2002 12:47 PM

just guessing :

does :

right click on the pivot heading buttons
select
push in the "enable selection" button

does that make any difference ?

HTH
Chris