Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Oct 15, 2019 11:55 am

Dear Sir/Madam,
I am using Excel 2007 version. But Errror message showing "This pivot table was created in a later version of excel and can't be updated in this version".
Is there any possibility or availability to get the results in Version Of Excel-2007?
Thank You

ManiDotnet
 
Posts: 2
Joined: Tue Oct 15, 2019 9:07 am

Wed Oct 16, 2019 5:47 am

Hi,

Thanks for your inquiry.
Pivot table could work in Excel 2007 Version. Please try the code below to set the Excel file version as Excel 2007 Version.

Code: Select all
            //Set the Excel file version as Excel Version 2007
            Workbook workbook = new Workbook();
            workbook.Version = ExcelVersion.Version2007;


If the code couldn’t solve your issue, to help us better investigate it, please offer us the following information.
1. Your input Excel file(if any);
2. The complete code you were using which could reproduce your issue directly.
You could upload them here or send us(support@e-iceblue.com) via email.

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Tue Oct 29, 2019 10:01 am

Hi,

Greetings from E-iceblue.
Have you tried the code I offered you last time? Does it solve your issue?
Could you please give us some feedback at your convenience?

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Tue Oct 29, 2019 12:46 pm

Ye.
The issue was cleared. Actually we trying the PIVOT method and combination of cells and filtration in the single sheet and that results in another sheet of same excel.
Thanks for your support.
Thanks

ManiDotnet
 
Posts: 2
Joined: Tue Oct 15, 2019 9:07 am

Wed Oct 30, 2019 1:08 am

Hi,

Thanks for sharing the solution.
Any question, welcome to contact us. Have a nice day.

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Return to Spire.XLS