After further investigation, this might be something to do with the 'Rebuild Sheet' function and not with the RefreshSheet macro. When I click 'Rebuild Sheet' I see the same behaviour: every worksheet is recalculated. This also seems to happen whenever I run any Cognos Office Automation functions.
I have a new workbook with two sheets both containing dynamic reports from different cubes. I change the parameters of both, then run this macro
Code: Select all
Sub test23()
Reporting.DynamicReports.GetAt(Application.ActiveSheet.Name).Item(0).Refresh
End Sub
And both sheets are recalculated. Formulas are set to 'Manual' so it shouldn't be automatically recalculating things.