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.
