I'm using Microsoft OLAP Pivot tables in Excel (2002, 2003) to access
an analysis services cube. The data associated in my dimension
selection values does not refresh when I click the refresh bottom
(time dimension data changing hourly). The data is stale until I close
and reopen the spreadsheet. Is this a know limitation when using Excel
to access an analysis services cube? I've tried refreshing the data
and refreshing the connection. The dimension data does not refresh
using the refresh options.

Any help or ideas will be appreciated.

Dan

Yes, dimension data won't change on refresh - only measure values will.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Yukon information at http://www.mosha.com/msolap/yukon.htm
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Dan" <dan.dressel (AT) tectastic (DOT) com> wrote

Thank you. So, it sounds like closing the speadsheet and reopening the
speadsheet is the only way to refresh the dimension data.

Dan

"Mosha Pasumansky [MS]" <moshap (AT) online (DOT) microsoft.com> wrote