Which version of ProcessRobot or Winautomation ?
1. Ensure Excel is fully activated and the default program for .xlsx files.
2. Try Disable - "Refresh data when opening the file" under Pivot Table Options > Data
Softomotove: RPA in Retail: Service Industry Best Practices and Use Cases