Disabling the refresh of a pivot table

=?Utf-8?B?Tmly?=

Guest

Posts: n/a

12th Mar 2007

Hi,

I'm trying to programatically disable the refresh of a specific pivot table,
which is connected to a local cube.
In Excel 2003 I disabled the "refresh data" and "refresh all" buttons.

1. Is it possible to disable the Refresh and Refresh All buttons in Excel
2007? I understand that some or all Ribbon UI buttons can't be disabled.

2. Is there any other way to prevent it, say overriding the Refresh action
of the pivot table?

Thanks

« Running Macro at sheet activation | Create a pivot table with a local connection »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range)	Mike C	Microsoft Excel Programming	3	15th Feb 2008 06:22 AM
Create refresh button in worksheet to refresh Pivot Table Data	=?Utf-8?B?Um9u?=	Microsoft Excel Worksheet Functions	1	13th Oct 2007 01:20 AM
Timing of automatic query refresh and macro pivot table refresh	=?Utf-8?B?ZHV0dHk=?=	Microsoft Excel Programming	2	1st Dec 2004 07:19 PM
Pivot table refresh - how do you stop auto-refresh?	bscruggs@microsoft.com	Microsoft Excel Misc	1	21st Feb 2004 12:05 PM
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH	Ken Roberts	Microsoft Excel Programming	3	11th Sep 2003 06:02 AM