View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
TimS TimS is offline
external usenet poster
 
Posts: 6
Default Excel hangs when copying sheet with charts to Powerpoint

Shane,
Thanks for your input but the problem is occurring before opening
Powerpoint. They have Excel open, highlight the charts and graphs to be
copied to Powerpoint, then hit copy. At that point, if they open Powerpoint
(or Word), Excel stops responding and starts going through the document
recovery process, as if Excel just died with a file open and you restarted
it. If they don't hit copy and open Powerpoint or Word before they hit copy,
then everything's fine. Excel never stops responding. Also they can't open
the Powerpoint file and insert the Excel sheet, since they only need part of
the Excel file copied, not the entire file's contents.

"Shane Devenshire" wrote:

Hi,

I don't know if this will help, but open PowerPoint, then right click the
Windows Taskbar and choose Show windows side by side or something similar
Move to Excel and highlight the range you want to copy
Place the mouse along the edge of the selection until it becomes a white
arrow, hold down the Ctrl key and drag into PowerPoint and release the mouse
first.

Alternatively, in PowerPoint you can choose to Insert, Object, Create from
File, locate your file and bring it in.


If this help, please click Yes.

Cheers,
Shane Devenshire


"TimS" wrote:

I have an unusual situation with an Excel spreadsheet. The spreadsheet has
multiple tabs, one of which has a chart and three graphs reading data from
the chart. If our user copies the contents of this tab then goes to open a
Powerpoint file, or just Powerpoint itself, Excel shows not responding.
Looks like Excel goes through a file recovery step, because after two
minutes, Excel shows it has recovered the file and Powerpoint will then open.
Happens with Word as well, so it must be something Office related in
general. The unusual thing is I found on my pc if I remove one particular
chart from this tab, then I don't have this problem, but the user still does.
The workaround I found is open the original spreadsheet, open Powerpoint,
then perform the copy step of the data on the Excel tab. Works every time.
Has anybody run across this before? We both have Office XP SP3. The user
has even gone as far as recreating all the charts on this tab and the problem
is still there. Open for ideas on this. Been researching on the web but I
can't find anything on this odd one. Thanks.