Skip to Content
0
Former Member
Nov 03, 2009 at 02:44 PM

Turn of automatic refresh in EVEXP report

31 Views

Hi,

I have some reports, were after changing CV it always automatic refreshes the worksheet. These are EVEXP expansion.

I have turned of all workbook options and added a macro to disable automatic recalculation in excel before CV change and put it back on after the CV change.

But still the report starts a query to the server after changing the CV member. I have tested in SP4 and SP5 and in both version I have this issue (even in apshell). Anyone got a solution for this?

Regards Tim Vierhout