We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

External Link of Pivot table got deleted when converting XLS file to XLSM

Hi,
I am converting the attached XLS file into XLSM format, after conversion the XLSM file is removing the external link which is present for the pivot table.
This link is present at “\xl\pivotCache_rels” path
Could you please do the needful to address this issue.
TemplateFile-PivotTable-ExternalLink-Deleted.zip (15.3 KB)

@vedavyas.velaga,

Thanks for the template XLS file.

I did evaluate your issue a bit. Could you please share some screenshots to compare source (xml) data of input XLS file with output XLSM file @ "\xl\pivotCache_rels” path. This will help us evaluate your issue precisely on our end so we could log it appropriate ticket for it.

Hi Amjad,
Thanks for the quick reply.
As it is xls (binary) file I have converted it into xlsm using MS Excel and verified for the source xml file. I have attached the same xml file here.
But when using Aspose to convert this xls file into xlsm, this external link is not present.
pivotCacheDefinition-XML.zip (31.2 KB)

@vedavyas.velaga,

Thanks for the sample files.

I noticed the issue as you mentioned by converting your template XLS to XLSM file format. I found after conversion, the XLSM file is removing the external link which is present for the pivot table:
e.g.
Sample code:

Workbook workbook = new Workbook("e:\\test2\\TemplateFile-PivotTable-ExternalLink-Deleted.xls");
workbook.Save("e:\\test2\\out1.xlsm", Aspose.Cells.SaveFormat.Xlsm); 

I have logged a ticket with an id “CELLSNET-51419” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.