We are on SP9 with Client 9. The issue is that in the Workbook Options, Refresh Options section the boxes to indicate refresh preferences are not accessible..instead they are "greyed" out. The box to Allow Changes by Users is OK..white box and checked. Impact on the reports is that cells containing EVCVW formulas for dimension member changes are not refreshed by a double click on the cell to select a new member...instead the old member stays put in the cell. However, the Action Pane CVW is updated with the new member selection. Executing the report results in the right data and updated cells in the body of the report. However, this is not correct behavior or so it seems. Why are the Refresh Option boxes inacessible - "greyed" out? How do we fix this so that the boxes are white and accessible to users once again?
Thank you.