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