I have created pivot cube using Sqlserver 2005 (SSAS). The cube successfully refreshed with 5 dimensions in Excel 2007. Since the same is not working in Excel 2000. Find the below error message while accessing the cube in Excel 2000.
"Excel cannot display this one, bec rows has more than 65536 or columns has more than 16336 columns...."
but the cube does not exceeds the mentioned limits [ have identified thru excel 2007].
Am waiting for valuable reply..