After the August Excel Update (i have an office 365 subscription) some of the templates i use get corrupted (can't be opened in Excel) after opening and saving with Flexcel 6.14.
The same files saved with Excel before the update work perfectly but once they are saved with the latest version (Version 1707 Build 8326.2096 Click-to-Run) i cant use them with flexcel. The error i get from Excel and an XML tool when i try to open them is:
Namespace prefix xr2 for uid on sparklineGroup is not defined
It seems like some schema changed and it is no longer compatible with what flexcel is doing, here are the worksheet sections in the xml for the worksheets (saved in Excel) that have problems
Before update:
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">
After update:
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac xr xr2 xr3" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2" xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3" xr:uid="{00000000-0001-0000-0A00-000000000000}">