Analysis Cubes Creating Pivot Error - Cannot access file

So you are creating a pivot after upgrading and then when you save the file, you get an error that the file cannot be accessed and it refers to an excel file in the folder of the older version of Dynamics GP.



What to do:
- Change the Server name in the Pivot window which is Microsoft Dynamics GP>> Tools>> Analysis Cubes>> Create PivotTable Reports.
- Pick back the module/cube
- Click Save.
-This will generate the pivot to the new GP version.
-Now you can click excel icon to open your Pivot.