Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access vba courses - Excel Pivot Table Cache

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

access vba courses - Excel Pivot Table Cache

Resolved · Low Priority · Version Standard

Reply Fri 25 May 2007, 09:52Delegate Lawrence said...

Lawrence has attended:
Powerpoint Intermediate Advanced course
Excel VBA Intro Intermediate course

Excel Pivot Table Cache

Hello,

Could you please tell me how I can clear the cache of a pivot table without creating a new table.

Example in my first set of data I have items 'A', 'B' and 'C' and therefore these appear in the pivot, however when I generate a new set of data I now have the items 'A', 'B' and 'D'. In the pivot table memory I still see A B C and now D (eventhough C is no longer in my data). How can I clean the pivot table to remove C?

Thanks,

Lawrence

For upcoming training course dates see: Pricing & availability

Reply Fri 8 Jun 2007, 10:52Trainer David said...

RE: Excel Pivot Table Cache

Lawrence

On the Pivot table toolbar there is a red exclamation mark, for refreshing data, click that whilst you are in the pivot table.

let me know if this works for you.

regards

dave

Access articles

· How To Use Tabs To Show Lots Of Related Data On One Form In Access
· Getting To Grips With Templates In Access 2007
· Guide To Adding A Text Box Form Control In Access 2010
· How To Change The Data Displayed In A Linked Field In An Access Table
· How Microsoft Access grows with your company

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips