Hi Viv:
Which version of Excel are you using? Did you get any error message when you were saving the workbook? How was the PivotTable created? Did it contain external data connections?
It could be add-ins. To isolate this, start excel though safe mode. Then create a same PivotTable see if it could be saved.
It could also be compatibility issue. Were the work book and PivotTable created with same version Excel, like all were created by Excel 2013? To isolate this issue, please create the workbook and PivotTable with same version of Excel. See if it could be saved.
It would be better if you could share us more detailed information, like a screen grab or a detailed error message.
Here is the warning that I get, I am using 2010. I am creating the pivot table within the 2010 excel workbook. If I remove the pivot it saves fine or if I copy the pivot out of the excel doc into a new one and then paste it back in.
Hi Viv:
Thanks for the information, please try following approach and let me know the result:
Before trying these, please make a backup of file first
1.Open the file in safe mode, create the pivot table then save the file
2.Create the Pivot Table by Pivot Table wizard instead of the Insert Tab on the Ribbon
3.Run Excel as administrator, create the chart and save the file
4.Save the file in a different type, like .xlsm or .xlsb
5.Try to save the file in a new location, meanwhile, save a new file to current location
6.Edit Registry Key:
> Open command line as administrator
> Unregister and re-register MSCOMCTL.OCX
For 64 bit system:
- regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX
- regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX
For 32 bit system:
- regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX
- regsvr32.exe C:\Windows\System32\MSCOMCTL.OCX
>NOTE: Before modifying the Registry Key, export the current key to your local
machine.So you will be able to get the original Key back if something goes
wrong
Rename:
HKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0
To:
HKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0OLD
If renaming the key doesn't work. The key has to be deleted.
Afterward, follow steps 1 and 2 to unregister and re-register MSCOMCTL.OCX
Reference: This blog
Let me know if any of above approach work.
Also let me know if none of above works. If its this case, send your file through Email to: ibsofc@microsoft.com.
Thanks.
- Edited by Chloe WangModerator 22 hours 9 minutes ago