Can you think of any reason why a pivottable I have created will

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. 

I'll find out the info and get back to you. Thanks.

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