I was eventually asked to create a pivot table and within the hour my fears were gone. With Microsoft Excel for Mac, creating a pivot table is easily achieved in just a few steps using the toolbar. No formulas or shortcuts necessary! Step 1: The original data. For this example our data for the pivot table will be in Sheet 1. Release note(s) and a comprehensive list of defect corrections for the SPSS Statistics 23.0 Fix Pack 2. Details of the fixes are listed below under the tab for the respective Fix Pack.

See solution in other versions of Excel: • • • • • If you want to follow along with this tutorial, download the example spreadsheet. Steps to Change the Data Source of a Pivot Table To change the data source of an existing pivot table in Excel 2016, you will need to do the following steps: • Select any cell in the pivot table to reveal more pivot table options in the toolbar. In this example, we have selected cell A1 on Sheet2. You now should see 2 new tabs appear in the toolbar called Analyze and Design. • Select the Analyze tab from the toolbar at the top of the screen. In the Data group, click on Change Data Source button and select 'Change Data Source' from the popup menu.

• When the Change PivotTable Data Source window appears, change the Table/Range value to the new data source that you want for your pivot table and then click on the OK button. In this example, we want to change the range from Sheet1!$A$1:$F$16 to Sheet1!$A$1:$F$17 because we have added one more row to our data in Sheet1. • Now when you return to your pivot table, it should automatically refresh the pivot table and display the information from the new data source. In this example, Order ID 10252 now shows in the pivot table results.

I have created a spreadsheet in Excel 2013 that gets data from a CSV file, then made a pivot table based on the raw data and a chart to visualise it. The connection was also added to the data model and was configured to refresh upon opening the spredsheet. However, whenever I open the file I get the error message: We found a problem with some content in [file]. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes. After I click 'Yes', Excel tells me it 'was able to open the file by repairing or removing the unreadable content'. The data seems to update fine.

When I save the file again, Excel goes through the 'Save as' routine, but lets me overwrite the file anyway. This process is repeated every damn time I open the file. • If I unlink the raw data table from the CSV file, the problem disappears.

• If I reconnect to the CSV file, it problem re-appears. • Even if I remove all other sheets, or start from a new file, and add the CSV file, the problem re-appears.

Disk utility program for mac. Some bad blocks, bad sectors and media errors will not stop DiskWarrior. Just plug a new drive into your Mac and let DiskWarrior copy your good files from the failing hard drive to the new drive. File paths, permissions, invalid plists and other problems are tested to ensure your files can be found when you need them. DiskWarrior is so advanced it can even recover your data from a failing drive. DiskWarrior diagnoses common file problems.

After much Googling, trial and error I finally stumbled across on Microsoft Answers, where Sridhar suggests this workaround (emphasis mine): This happens only if I 'Add to data model' AND set the 'Refresh data when opening the file' during the creation of the connection. If I dont set the 'Refresh data when opening the file' and create the table and later go to 'Connections -> Properties' and it set it again then this does not happen. I can confirm that this solved the issue in my case too. This is the checkbox to leave unchecked when adding the connection: To enable this option after creating the connection: • Click on the 'Data' tab, then 'Connections' • Select the appropriate connection (not the data model), click 'Properties' • Check 'Refresh data when opening the file' (see screenshot above) • Click 'OK', then 'Close'.