View Single Post
  #1   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

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.