Active Forms - Recalcs/Rebuilds on multiple sheets

[chewza]

Hi there

I have an active form with 2 sheets:
sheet1 with the report I actually require
sheet2 showing a report from my parameters cube - shows current financial year etc

On sheet1, I have hidden the active form title rows, and put in my own "user friendly" ones. To display Financial year in the column name, I use an excel formula to link to the relevant cell in sheet 2.

Problem - each time I recalc/rebuild sheet 1, the values in sheet 2 go haywire. I have also seen this behavior before, where recalcs seem to mess up values on other sheets....??

Any ideas??

Chris

[par3]

Chris,

Try and insert a action button which Rebuilds the entire sheet.

Otherwise use a Excel button and link a macro to it in which the F9 button has been pressed.