problem getting refreshed data while accessing the cube from excel(OWC)

If I save a report using a cube in an excel spreadsheet, the next time when I open it, and try to drag a dimension, I cannot see any data. I need to refresh the document every time

I process the cube.

Is there way we can automatically refresh these reports ? Has anyone had this problem

before?

I'll appreciate your help.

thanks,

Rok

In 2007, you can configure your connection to refresh data everytime the file is opened or on a fixed interval. In 2003, this appears as a Pivot Table option.

B.