Chart data (excel format) in power point charts

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I've been creating simple charts in power point (excel opens and I can create
the chart and it looks great). Once I save the file and reopen the ppt file
later, the chart is still there and looks correct, but I can't open the excel
file to modify any data. When I double click on the chart and then click
edit data, nothing happens (Excel does not open). Any ideas what I'm
screwing up? I read some similar posts, but they did not help, the UPDATE
button in excel is grayed out and I can't UPDATE the chart data, I also could
not insert object create new, browse, and select the excel spreadsheet (I get
a not enough memory message).
 
I get the "not enough memory" thing a lot. I think it's a leak in IE, but I
don't know exactly what causes it. It's maddening. Rebooting should take
care of it, though. If not, holler back.
 
I've tried rebooting with no luck. The real question I have is why excel
won't open up when I double click the chart in powerpoint (or even when I
click on the edit data button). The INSERT OBJECT etc. comment was a
"work around" I saw on a post here, but I shouldn't have to do this.
Everything is great until I save the powerpoint file, and then try to go back
and make a change to the chart. I cannot get the excel table (that the chart
is based on) to open up again.

Echo S said:
I get the "not enough memory" thing a lot. I think it's a leak in IE, but I
don't know exactly what causes it. It's maddening. Rebooting should take
care of it, though. If not, holler back.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


Ed said:
I've been creating simple charts in power point (excel opens and I can
create
the chart and it looks great). Once I save the file and reopen the ppt
file
later, the chart is still there and looks correct, but I can't open the
excel
file to modify any data. When I double click on the chart and then click
edit data, nothing happens (Excel does not open). Any ideas what I'm
screwing up? I read some similar posts, but they did not help, the
UPDATE
button in excel is grayed out and I can't UPDATE the chart data, I also
could
not insert object create new, browse, and select the excel spreadsheet (I
get
a not enough memory message).
Click to expand...
Click to expand...
 
You're just using Insert | Chart in PPT to insert the chart, right? Or are
you opening Excel, creating the chart, and copying/pasting it into PPT?

Try running Detect and Repair.

If you open Excel first, can you edit the chart then?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


Ed said:
I've tried rebooting with no luck. The real question I have is why excel
won't open up when I double click the chart in powerpoint (or even when I
click on the edit data button). The INSERT OBJECT etc. comment was a
"work around" I saw on a post here, but I shouldn't have to do this.
Everything is great until I save the powerpoint file, and then try to go
back
and make a change to the chart. I cannot get the excel table (that the
chart
is based on) to open up again.

Echo S said:
I get the "not enough memory" thing a lot. I think it's a leak in IE, but
I
don't know exactly what causes it. It's maddening. Rebooting should take
care of it, though. If not, holler back.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


Ed said:
I've been creating simple charts in power point (excel opens and I can
create
the chart and it looks great). Once I save the file and reopen the ppt
file
later, the chart is still there and looks correct, but I can't open the
excel
file to modify any data. When I double click on the chart and then
click
edit data, nothing happens (Excel does not open). Any ideas what I'm
screwing up? I read some similar posts, but they did not help, the
UPDATE
button in excel is grayed out and I can't UPDATE the chart data, I also
could
not insert object create new, browse, and select the excel spreadsheet
(I
get
a not enough memory message).
Click to expand...
Click to expand...
Click to expand...
 
Thanks for checking back, I have a friend at work who isn't having this
problem (same OFFICE 07 suite), so it's probably just my computer (I'll have
my IT guys check it over/detect and repair).

but....
no, even if I open up EXCEL first, I can't get the chart data to show up.

I create the charts in power point by using the INSERT CHART symbol. That
opens up EXCEL in a separate window and I put the labels and data into the
excel chart. It looks good and I can close out EXCEL and move to other ppt
slides to do work. As long as I don't close out powerpoint, I can come back
to that chart slide and pull up the excel data using the EDIT DATA button.
The problem comes when I SAVE the ppt file and close out and try to come back
to the slideshow to do work later. Now when I try to EDIT DATA underneath a
chart the excel window does not appear no matter what I try (double clicking
the chart, EDIT DATA, right click EDIT DATA, etc.)
I'm saving the ppt file in the STANDARD format .pptx, I was originally
saving in 97-2003 format but got messages that the charts would not be
editable if I did.
I did see some posts about the same type of problem, but one of the
"solutions" was to put a registry key in to make it handle charts like
ppt2003 version and another was a workaround that didn't use INSERT CHART,
it used INSERT OBJECT CREATE NEW, then BROWSE for the EXCEL CHART you wanted.

Sounds like my computer and not a software issue (which is all I was worried
about), so I'll let you know if my IT guys can't fix it. Thanks again.
 
Thanks for letting me know how you're creating the charts. If you were
copying/pasting from Excel, that links to PPT now, so it could have been an
issue of you not saving the Excel file. But since you're using Insert |
Chart in PPT, that embeds the Excel chart -- no need for you to save
anything there.

Anyway, that makes me think it's an antivirus issue. As an example, Norton
has known issues with the Office plug-in causing these types of issues.
Here's the fix for it: Norton Anti-Virus and Office
http://www.pptfaq.com/FAQ00387.htm Other A/V software may have similar
issues.

As for Diagnostics/Detect and Repair, go to Office Button | PPT Options |
Resources and run diagnostics from there.
 
Echo S, Still no luck with the excel chart data problem. I talked with my
IT guys and we ran detect and repair with no problems found, we also
completely uninstalled and reinstalled the office 07 software, and have tried
powerpoint with my login and the admin login both with same results. My IT
guys did not think it was AV software since all of the folks in my office
have the same software/computer setup and they aren't experiencing any
problem. Tomorrow I'll try turning off AV software and see if it does fix
the issue. Next option if that doesn't work is to start over on my computer
and reload all software from scratch. I did get some error messages at one
point (with the SEND TO MICROSOFT option) and I sent them in to MS for
analysis. I've also noticed when I try to "CONVERT" some powerpoint files, I
get a CAN'T COVERT message while others in my office have no problem
converting to 07 format and working on the slides.

Echo S said:
Thanks for letting me know how you're creating the charts. If you were
copying/pasting from Excel, that links to PPT now, so it could have been an
issue of you not saving the Excel file. But since you're using Insert |
Chart in PPT, that embeds the Excel chart -- no need for you to save
anything there.

Anyway, that makes me think it's an antivirus issue. As an example, Norton
has known issues with the Office plug-in causing these types of issues.
Here's the fix for it: Norton Anti-Virus and Office
http://www.pptfaq.com/FAQ00387.htm Other A/V software may have similar
issues.

As for Diagnostics/Detect and Repair, go to Office Button | PPT Options |
Resources and run diagnostics from there.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


Ed said:
Thanks for checking back, I have a friend at work who isn't having this
problem (same OFFICE 07 suite), so it's probably just my computer (I'll
have
my IT guys check it over/detect and repair).

but....
no, even if I open up EXCEL first, I can't get the chart data to show up.

I create the charts in power point by using the INSERT CHART symbol.
That
opens up EXCEL in a separate window and I put the labels and data into the
excel chart. It looks good and I can close out EXCEL and move to other
ppt
slides to do work. As long as I don't close out powerpoint, I can come
back
to that chart slide and pull up the excel data using the EDIT DATA button.
The problem comes when I SAVE the ppt file and close out and try to come
back
to the slideshow to do work later. Now when I try to EDIT DATA underneath
a
chart the excel window does not appear no matter what I try (double
clicking
the chart, EDIT DATA, right click EDIT DATA, etc.)
I'm saving the ppt file in the STANDARD format .pptx, I was originally
saving in 97-2003 format but got messages that the charts would not be
editable if I did.
I did see some posts about the same type of problem, but one of the
"solutions" was to put a registry key in to make it handle charts like
ppt2003 version and another was a workaround that didn't use INSERT CHART,
it used INSERT OBJECT CREATE NEW, then BROWSE for the EXCEL CHART you
wanted.

Sounds like my computer and not a software issue (which is all I was
worried
about), so I'll let you know if my IT guys can't fix it. Thanks again.
Click to expand...
Click to expand...
 
Turning off the AV won't do it, though -- you need to double-check it for
Office scanning plug-ins. Maybe check with the AV company directly. They may
have some info in their knowledge base.

You might want to put a call into Microsoft about this. I'm pretty sure
we've seen similar issues mentioned here, but I can't find them right now,
and I can't remember anything different that might have fixed the issue.

Oh, you do have SP1 for Office 2007 installed, right?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


Ed said:
Echo S, Still no luck with the excel chart data problem. I talked with
my
IT guys and we ran detect and repair with no problems found, we also
completely uninstalled and reinstalled the office 07 software, and have
tried
powerpoint with my login and the admin login both with same results. My
IT
guys did not think it was AV software since all of the folks in my office
have the same software/computer setup and they aren't experiencing any
problem. Tomorrow I'll try turning off AV software and see if it does fix
the issue. Next option if that doesn't work is to start over on my
computer
and reload all software from scratch. I did get some error messages at
one
point (with the SEND TO MICROSOFT option) and I sent them in to MS for
analysis. I've also noticed when I try to "CONVERT" some powerpoint
files, I
get a CAN'T COVERT message while others in my office have no problem
converting to 07 format and working on the slides.

Echo S said:
Thanks for letting me know how you're creating the charts. If you were
copying/pasting from Excel, that links to PPT now, so it could have been
an
issue of you not saving the Excel file. But since you're using Insert |
Chart in PPT, that embeds the Excel chart -- no need for you to save
anything there.

Anyway, that makes me think it's an antivirus issue. As an example,
Norton
has known issues with the Office plug-in causing these types of issues.
Here's the fix for it: Norton Anti-Virus and Office
http://www.pptfaq.com/FAQ00387.htm Other A/V software may have similar
issues.

As for Diagnostics/Detect and Repair, go to Office Button | PPT Options |
Resources and run diagnostics from there.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


Ed said:
Thanks for checking back, I have a friend at work who isn't having
this
problem (same OFFICE 07 suite), so it's probably just my computer (I'll
have
my IT guys check it over/detect and repair).

but....
no, even if I open up EXCEL first, I can't get the chart data to show
up.

I create the charts in power point by using the INSERT CHART symbol.
That
opens up EXCEL in a separate window and I put the labels and data into
the
excel chart. It looks good and I can close out EXCEL and move to other
ppt
slides to do work. As long as I don't close out powerpoint, I can come
back
to that chart slide and pull up the excel data using the EDIT DATA
button.
The problem comes when I SAVE the ppt file and close out and try to
come
back
to the slideshow to do work later. Now when I try to EDIT DATA
underneath
a
chart the excel window does not appear no matter what I try (double
clicking
the chart, EDIT DATA, right click EDIT DATA, etc.)
I'm saving the ppt file in the STANDARD format .pptx, I was originally
saving in 97-2003 format but got messages that the charts would not be
editable if I did.
I did see some posts about the same type of problem, but one of the
"solutions" was to put a registry key in to make it handle charts like
ppt2003 version and another was a workaround that didn't use INSERT
CHART,
it used INSERT OBJECT CREATE NEW, then BROWSE for the EXCEL CHART you
wanted.

Sounds like my computer and not a software issue (which is all I was
worried
about), so I'll let you know if my IT guys can't fix it. Thanks
again.
Click to expand...
Click to expand...
Click to expand...
 
Echo,

Yes, we have SP1 installed. I'm giving up and formatting the drive
tomorrow and re-installing the whole software package (our IT guys will clone
my hard drive from the master). I'm getting a message every time I boot up
about "a registry file was successfully recovered" anyway, so maybe that will
solve all of my problems at once. Thanks for trying to help.


Echo S said:
Turning off the AV won't do it, though -- you need to double-check it for
Office scanning plug-ins. Maybe check with the AV company directly. They may
have some info in their knowledge base.

You might want to put a call into Microsoft about this. I'm pretty sure
we've seen similar issues mentioned here, but I can't find them right now,
and I can't remember anything different that might have fixed the issue.

Oh, you do have SP1 for Office 2007 installed, right?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


Ed said:
Echo S, Still no luck with the excel chart data problem. I talked with
my
IT guys and we ran detect and repair with no problems found, we also
completely uninstalled and reinstalled the office 07 software, and have
tried
powerpoint with my login and the admin login both with same results. My
IT
guys did not think it was AV software since all of the folks in my office
have the same software/computer setup and they aren't experiencing any
problem. Tomorrow I'll try turning off AV software and see if it does fix
the issue. Next option if that doesn't work is to start over on my
computer
and reload all software from scratch. I did get some error messages at
one
point (with the SEND TO MICROSOFT option) and I sent them in to MS for
analysis. I've also noticed when I try to "CONVERT" some powerpoint
files, I
get a CAN'T COVERT message while others in my office have no problem
converting to 07 format and working on the slides.

Echo S said:
Thanks for letting me know how you're creating the charts. If you were
copying/pasting from Excel, that links to PPT now, so it could have been
an
issue of you not saving the Excel file. But since you're using Insert |
Chart in PPT, that embeds the Excel chart -- no need for you to save
anything there.

Anyway, that makes me think it's an antivirus issue. As an example,
Norton
has known issues with the Office plug-in causing these types of issues.
Here's the fix for it: Norton Anti-Virus and Office
http://www.pptfaq.com/FAQ00387.htm Other A/V software may have similar
issues.

As for Diagnostics/Detect and Repair, go to Office Button | PPT Options |
Resources and run diagnostics from there.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


Thanks for checking back, I have a friend at work who isn't having
this
problem (same OFFICE 07 suite), so it's probably just my computer (I'll
have
my IT guys check it over/detect and repair).

but....
no, even if I open up EXCEL first, I can't get the chart data to show
up.

I create the charts in power point by using the INSERT CHART symbol.
That
opens up EXCEL in a separate window and I put the labels and data into
the
excel chart. It looks good and I can close out EXCEL and move to other
ppt
slides to do work. As long as I don't close out powerpoint, I can come
back
to that chart slide and pull up the excel data using the EDIT DATA
button.
The problem comes when I SAVE the ppt file and close out and try to
come
back
to the slideshow to do work later. Now when I try to EDIT DATA
underneath
a
chart the excel window does not appear no matter what I try (double
clicking
the chart, EDIT DATA, right click EDIT DATA, etc.)
I'm saving the ppt file in the STANDARD format .pptx, I was originally
saving in 97-2003 format but got messages that the charts would not be
editable if I did.
I did see some posts about the same type of problem, but one of the
"solutions" was to put a registry key in to make it handle charts like
ppt2003 version and another was a workaround that didn't use INSERT
CHART,
it used INSERT OBJECT CREATE NEW, then BROWSE for the EXCEL CHART you
wanted.

Sounds like my computer and not a software issue (which is all I was
worried
about), so I'll let you know if my IT guys can't fix it. Thanks
again.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top