Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Excel hangs when copying sheet with charts to Powerpoint

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems copying charts into PowerPoint B&WCHARTS Charts and Charting in Excel 8 September 5th 06 02:54 AM
Help! How to add many excel charts into PowerPoint at once? Joules Charts and Charting in Excel 1 July 13th 06 06:58 PM
Charts in each sheet to Powerpoint [email protected] Charts and Charting in Excel 6 June 24th 05 10:48 PM
When Copying Excel Table to Powerpoint Alicia Excel Discussion (Misc queries) 1 March 30th 05 01:44 PM
Copying an Excel Graph to PowerPoint Sandy Charts and Charting in Excel 2 February 7th 05 11:58 PM


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"