I have an Excel workbook which has a connection to a Microsoft SQL Server OLAP Cube. The workbook contains many sheets and cells with CUBEVALUE formulas. When I update the cube, i then need to press the Refresh button in Excel to force Excel to retrieve the new values from the cube. This process takes long due to the size and complexity of the workbook. I need to find a way to force an update of a single cell in Excel, leaving the other values temporarily unrefreshed, until i manually force a full refresh of the workbook as i normally do.

How can this be done? I am open to any suggestions, including macros / scripts, and 'hacks' in Excel to refresh only one cell. Simply tweaking a bit the CUBEVALUE formula does not force a refresh of the cell's value.

Thanks