powerpoint >> Editing Charts in PPT Crashes Excel

by ampamm » Thu, 18 Jun 2009 11:53:48 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Almost every time I try to edit an existing chart with Excel in PPT, it crashes Excel and requires a restart. This doesn't happen when I first create a chart, but seems to be a problem when I go back to try to edit.

Is there a workaround/fix for this?

Similar Threads

1. edit excel chart that has been pasted into ppt

2. PPT hangs up when editing Excel charts

Editing PPT imbedded Excel charts, PPT constantly locks up, forcing me to 
have to recover the PPT file.  I know this problem has been documented... any 
fixes?  Thanx!
-- 
Bill

3. Cannot insert or edit charts (PPT OSX)

4. Still cannot insert or edit charts (PPT OSX)

Still waiting for any suggestions on my post from June 7...
Thanks.

5. When I open a 2004 PPT file in 2008 PPT, some Excel charts do not appear

6. PPT 2007 Need to Programmatically Edit Data in Charts

Up until now I have been generating PPT files by opening a PPT template, 
pulling records from Access, and using VBA code to populate the tables and 
graphs on the slides with data from the Access queries. The tables are easy, 
while the graphs I updated by putting data values into the graph's datasheet 
cells. 

Now with PPT 2007 the graphs are different. The datasheet is more like an 
Excel worksheet, with a "Chart" tab and a "Sheet1" tab at the bottom. I have 
tried every syntax I can think of to talk to this new type of datasheet using 
VBA, but nothing works. 

Now I read on various forums that the new PPT 2007 Chart object does not 
expose any methods that can be addressed using VBA. 

So I started writing an application to manipulate PPT slides using VB.Net. 
But I cannot find any examples that show how to use VB.Net code to 
programmatically update the data in the sheet behind the chart. 

What is the big secret to updating the Sheet1 cells in PPT 2007 charts? 
Where is the documentation for the 2007 PPT object model? I cant believe the 
ability to address datasheet cells direclty in code has been taken away. Does 
anybody know how to do this without going back to the old MSGraph model? 

Thanks for any help! 
SC
-- 
So Be It, Jedi!

7. Unable to edit data in PPT chart - Microsoft Office

8. Excel crashes when editing chart

I'm using VS .Net 2003 to write a C# com addin for Excel 2000.

At set intervals I am iterating through the Excel.Workbooks collection,
adding the FullName property of each Workbook to a collection. I have a
try..catch block around this code in case of any exceptions.

I have found one (strange) scenario which causes Excel to crash every time
using the addin described above. On Sheet1 insert values into cells A1 and
B1. Now Freeze Panes between columns A and B (select column B and select
Window->Freeze Panes). Now highlight the 2 cells and click the chart button.
I am using all the default values (i.e. I keep pressing Next) until the last
set of options (Step 4 of 4 - Chart Location) where I select to place the
chart as an object into Sheet2. The default column chart is correctly placed
into Sheet2 and displays my 2 columns. If you now right click on a white
area of the chart and select Source Data..., Sheet1 will now be displayed.
Excel will usually crash at this point or when either the OK or Cancel
button is pressed.

Can anyone help with this problem please?