Disabling the refresh of a pivot table

N

Nir

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
 

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

Pivot tables not refreshing after data source update 1
Refreshing Pivot table 1
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Hooking into Refresh/RefreshAll events from listobject 3
display pivot refresh date? 3
Refreshing NON-embedded External Data Connections 1
refresh multiple pivot tables in workbook 2
Pivot Table refresh in VBA code not working 0

Top