![]() ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |