If you only want to use some data in the file that cannot be opened, you can do this:

1. Create a new excel；;

2. Click to select the PivotTable report;

3. Select the PivotTable report to open the following window:

4. Select an external data source, and then select the excel file to use.