Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems copying charts into PowerPoint | Charts and Charting in Excel | |||
Help! How to add many excel charts into PowerPoint at once? | Charts and Charting in Excel | |||
Charts in each sheet to Powerpoint | Charts and Charting in Excel | |||
When Copying Excel Table to Powerpoint | Excel Discussion (Misc queries) | |||
Copying an Excel Graph to PowerPoint | Charts and Charting in Excel |