I am facing problems while accessing the cube's data from Excel 2000 through Microsoft Query option. I tried connecting to the same and i am getting the pivot table and the Measures/Dimensions List.
When I drop a few measures in the data area in the pivot table, I am able to retrieve the data. But when a calculated measure that involves calculation, is dropped in the data area, I am getting the following error in Excel.
"EXCEL.exe has generated errors and will be closed by windows. You will need to restart the program. An error log is being created. "
And the Excel window gets closed automatically. For your information, Excel 2000 is provided with OLDEDB 8.0.
But when I tried using Excel XP, I am not getting this error.
Could anyone identify the reasons for this problem? And what is the remedy? I need to access the cubes from Excel 2000(my requirement)