Home

Why do box/whisker graphs freeze when pasting from Excel workbook to PPT?

%3CLINGO-SUB%20id%3D%22lingo-sub-847381%22%20slang%3D%22en-US%22%3EWhy%20do%20box%2Fwhisker%20graphs%20freeze%20when%20pasting%20from%20Excel%20workbook%20to%20PPT%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847381%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20work%20in%20IT%20but%20my%20organization%20has%20quite%20a%20lot%20of%20Excel%20power%20users.%20I%20have%20a%20user%20who%20has%20been%20having%20issues%20when%20copy%2Fpasting%20certain%20box%20graphs%20from%20an%20Excel%20workbook%20to%20Powerpoint.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHe%20is%20using%20an%20Excel%20workbook%20that%20has%20a%20bunch%20of%20raw%20numbered%20data.%3C%2FP%3E%3CP%3EHe%20is%20generating%20the%20graphs%20based%20on%20that%20data%20on%20the%20same%20sheet%20as%20the%20data.%3C%2FP%3E%3CP%3EHe%20needs%20to%20present%20this%20data%20-%20so%20after%20he%20generates%20the%20graphs%2C%20he%20copies%20and%20pastes%20them%20(with%20formatting)%20into%20Powerpoint.%20After%2C%20when%20he%20tries%20to%20edit%20the%20graph%20in%20any%20way%20(resize%2C%20change%20values%2C%20etc)%20besides%20just%20moving%20the%20graph%20around%2C%20it%20will%20freeze%20powerpoint%20to%20the%20point%20where%20he%20either%20needs%20to%20kill%20it%20in%20task%20manager%20or%20wait%20about%205%20minutes%20for%20Powerpoint%20to%20unfreeze%2C%20catch%20up%20with%20the%20changes%20and%20allow%20him%20to%20resume%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20does%20not%20happen%20with%20all%20graphs%20-%20it%20does%20not%20happen%20with%20all%20his%20box%20graphs.%3C%2FP%3E%3CP%3EI've%20already%20suggested%20he%20generates%20all%20graphs%20on%20a%20sheet%20separate%20from%20the%20workbook%2C%20OR%20doing%20all%20graph%20manipulation%20in%20Excel%20before%20pasting%20it%20into%20PPT%20-%20but%20he%20isn't%20satisfied%20with%20this%20as%20a%20workaround%20since%20he%20claims%20he's%20been%20working%20this%20way%20between%20excel%2Fppt%20for%20awhile%20and%20this%20freezing%20incident%20only%20started%20happening%20recently.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20advice%20as%20to%20why%20this%20happens%20and%20how%20I%20can%20present%20it%20in%20a%20way%20where%20he%20isn't%20going%20to%20feel%20like%20I'm%20forcing%20him%20to%20completely%20change%20his%20workflow%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847381%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EEXCEL%20GRAPH%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerPoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
chrisftl
Occasional Visitor

Hey all,

 

I work in IT but my organization has quite a lot of Excel power users. I have a user who has been having issues when copy/pasting certain box graphs from an Excel workbook to Powerpoint. 

 

He is using an Excel workbook that has a bunch of raw numbered data.

He is generating the graphs based on that data on the same sheet as the data.

He needs to present this data - so after he generates the graphs, he copies and pastes them (with formatting) into Powerpoint. After, when he tries to edit the graph in any way (resize, change values, etc) besides just moving the graph around, it will freeze powerpoint to the point where he either needs to kill it in task manager or wait about 5 minutes for Powerpoint to unfreeze, catch up with the changes and allow him to resume work.

 

This does not happen with all graphs - it does not happen with all his box graphs.

I've already suggested he generates all graphs on a sheet separate from the workbook, OR doing all graph manipulation in Excel before pasting it into PPT - but he isn't satisfied with this as a workaround since he claims he's been working this way between excel/ppt for awhile and this freezing incident only started happening recently. 

 

Any advice as to why this happens and how I can present it in a way where he isn't going to feel like I'm forcing him to completely change his workflow?

Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies