![]() ![]() Search for the attribute: groupBy="months" (make sure you prettify your xml so it is not one long condensed line, if using Visual Studio Ctrl+K,Ctrl+D) My copy has 800 lines of xml or so, and I imagine it could be a lot more than that even, but focus only on the portion you want to reformat. Inside my 'unzipped excel file', the file path is: Root > xl > pivotCache > pivotCacheDefinition1.xml Regardless of your method, now navigate to the "PivotCache" for your pivot table. ![]() xlsxĥ.) Warning, This method often corrupts my files, but not always, so I use OOXML Package editor in Visual Studio instead. Or "least advised" way 1.) Change your filename from "MyExcelFile.xlsx" to "MyExcelFile.zip"ģ.) Change the format (as explained below)Ĥ.) Zip it all back up and change extension to. Or use a "simpler" Chrome Based Extension (Drag and Drop Excel file onto it): (remember to download your new file after saving changes to it) "Best way" Use Visual Studio extension (OOXML Package Editor) to open/edit excel file directly: ![]() If you do not know how to open an excel document (to view the xml documents it is composed of internally) please reference one of these links: I was able to solve this issue by manipulating the inner OOXML(Office Open XML) of the Excel document.
0 Comments
Leave a Reply. |