Delete the drawing.xml from excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-1551731%22%20slang%3D%22en-US%22%3EDelete%20the%20drawing.xml%20from%20excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551731%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20anyway%20that%20I%20can%20delete%20the%20drawing.xml%20from%20the%20excel%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESometime%20my%20customer%20send%20me%20some%20excel%20file%20(.xlsx)%20that%20maybe%20has%20been%20edited%20too%20many%20times%20and%20every%20time%20when%20I%20open%20it%2C%20excel%20may%20take%20like%205%20minutes%20to%20open%2C%20and%20will%20take%20from%2010%20second%20to%201%20minutes%20to%20response%20any%20action%20I%20take.%20The%20file%20is%20not%20that%20big%20(900KB)%20so%20I%20wonder%20why%20it%20works%20like%20this.%20By%20doing%20some%20research%20I%20find%20out%20that%20I%20can%20rename%20the%20.xlsx%20file%20to%20.rar%20file%20and%20open%20it%2C%20I%20found%20out%20that%20there%20is%20a%20drawing.xml%20that%20have%2045MB.%20It%20looks%20like%20the%20original%20file%20has%20mass%20amount%20of%20invisible%20object%20in%20it%20and%20cause%20this%20problem.%20But%20right%20now%20I%20have%20a%20problem%20that%20actually%20what%20I%20need%20to%20do%20on%20the%20excel%20file%20is%20just%20open%20it%2C%20adjust%20the%20printing%20area%20and%20printing%20it.%20It%20is%20not%20worth%20it%20for%20me%20to%20spend%20like%2015%20minutes%20to%20open%20the%20file%20and%20delete%20all%20the%20invisible%20object.%20Is%20there%20any%20other%20faster%20way%20to%20delete%20that%20file%20or%20just%20let%20excel%20ignore%20that%20file%20so%20that%20I%20can%20open%20this%20kind%20of%20sheet%20faster%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1551731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Is there anyway that I can delete the drawing.xml from the excel file.

 

Sometime my customer send me some excel file (.xlsx) that maybe has been edited too many times and every time when I open it, excel may take like 5 minutes to open, and will take from 10 second to 1 minutes to response any action I take. The file is not that big (900KB) so I wonder why it works like this. By doing some research I find out that I can rename the .xlsx file to .rar file and open it, I found out that there is a drawing.xml that have 45MB. It looks like the original file has mass amount of invisible object in it and cause this problem. But right now I have a problem that actually what I need to do on the excel file is just open it, adjust the printing area and printing it. It is not worth it for me to spend like 15 minutes to open the file and delete all the invisible object. Is there any other faster way to delete that file or just let excel ignore that file so that I can open this kind of sheet faster? 

0 Replies