Allow refresh of individual queries in workbook is not working

Hi,

We are in EHP1 SP08, BI Analyzer 7.20 SP2 .

In workbook I have 2 queries I checked the "Allow refresh of individual queries" but I am unable to refresh my queries individual .

I tried all the options by removing "Process variables on Refresh", " Refresh workbook open" ,Display duplicate variables once.

I appreciate if anybody share with the solution

we are using OFFICE 2007.

is there any setting required in Excel.

I am thinking "CALLBACK" Macro may not functioning correctly.