In Excel 2007 Analysis Services 2005 Pivot Table Field list is empty
Q: In Excel 2007 Analysis Services 2005 Pivot Table Field list is empty, how to fix this?
A: First make sure that client has access rights to analysis services cube. If permissions are set properly, and you still see empty Pivot Table field list, it could be related to the fact that you had installed Office 2007 beta on that machine and did not uninstall it properly.
To fix this:
- uninstall Microsoft Office 2007. Follow steps in this link to remove some files/folders manually: http://support.microsoft.com/kb/928218
- Reinstall Office 2007.