Using a freeform report i have buildt a sales analysis for our different
deparments. And i have placed each department on a seperate sheet in my
excel workbook.

Sheet1 is showing the total for the company. sheet2 is showing department A,
sheet3 department B and so on.

I am sharing some of the pagefilters among all the sheets so i can select a
date or a periode using the headfilters on sheet1 and all the formulas on
the other sheets is using that headfilter from sheet1.

This is working just fine as long as i refresh each of the sheet in my
workbook. All the refresh options that are offerend in the cube analysis
add in seems to work only on the active sheet.

So now i am looking for a way to update all the sheets in my workbook at the
same time. I tried to record a macro that did this, but the only command
that was recorder what sheets(sheet2).select. The refresh report command is
not beeing recorded in my macro.


Does anyone have any ide on how i can refresh the enitre workbook not having
to do a manual refresh of all the sheets in my workbook ?