Thursday, November 05, 2015

Make custom Pivot Table Style available in multiple Excel files

When you create a custom Pivot Table Style, it remains available only for the file it was created in. If you try to apply the same style to a different file you'll realize that the custom style doesn't appear in the list of available styles for new file. 

In order to transfer the custom style or to save it for other Excel files, follow these steps:

1. Select the entire pivot table (Select --> Pivot Table) where the custom style is already applied and copy (Ctrl+C). 
2. Paste this pivot table in a temporary sheet in a new file or your destination file. 
3. The custom style will now appear in the list of available styles. 
4. Delete the copied pivot table. 

Monday, October 26, 2015

Excel Error 2010 /xl/calcChain.xml

Recently, one of the Excel 2010 files which I have been using for the past few months to make regular updates in, suddenly ran into issue and started to show error - Records removed from /xl/calcChain.xml.


To resolve this issue, follow these instructions:

1. Change the Excel file's extension from .xlsx to .zip

2. Unzip the contents and go to /xl/ folder.

3. Delete caclChain.xml

4. Re-zip the contents of the folder

5. Change the extension from .zip back to .xlsx.

 

Upon opening the file, if Excel will not find calcChain.xml, it will recalculate the formulas and will re-create the calcChain.xml file.