Error message: This PivotTable was created in a later version of Excel and can't be updated in this version. To update it, click OK, and then open the workbook in the version of Excel it was originally created in.
User Credential Issues
Description: This error occurs, likely because the user has not entered correct (or any) credentials.
Solution: Check that the file has macros enabled and then attempt to use the proper credentials under security. If that doesn't work, try closing out of the cube and reopening it.