Cannot paste excel into powerpoint

M

Mike H

We are suddenly unable to paste Excel charts into powerpoint presentations.
This happens on all 80 + of our workstations. Office 2003 sp3 was recently
rolled out to all the workstaions and I suspect that this is a result. All
PC's are Win XP sp3, Office 2003 sp3 fully patched. When they try to paste a
spreadsheet into a power point or if they try double-click to edit an Excel
spreadsheet which has been inserted into PowerPoint, they get te following
errors:

1) Error accessing file. Network connection may have been lost.
2) Microsoft Office PowerPoint can't start the application required to open
this object. An error occurred and this feature is no longer functioning
properly. Would you like to repair this feature now? (The repair function
appears to complete, but does not resolve the problem)
3) There isn't enough memory available to read worksheet.

The same 3 errors occur over and over. I have tried a newer version of .net
(v2 sp2), I can't think of anything else to try (Office 2003 sp3 cannpt be
uninstalled). Any help would be great as I have 3 divisions trying to do
year end financial presentations for ownership and they are not very happy
that we do not have a solution.
 
M

Mike H

No luck, none of these resolved the issue. One more observation it appears
to be a visual basic issue as the first error is visual basic based (error
window says Microsoft visual basic) errors 2/3 are powerpoint.

Echo S said:
Try the stuff here:

http://www.pptfaq.com/FAQ00236.htm

re-registering OLE seems to work well lately.

--
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


Mike H said:
We are suddenly unable to paste Excel charts into powerpoint
presentations.
This happens on all 80 + of our workstations. Office 2003 sp3 was
recently
rolled out to all the workstaions and I suspect that this is a result.
All
PC's are Win XP sp3, Office 2003 sp3 fully patched. When they try to
paste a
spreadsheet into a power point or if they try double-click to edit an
Excel
spreadsheet which has been inserted into PowerPoint, they get te following
errors:

1) Error accessing file. Network connection may have been lost.
2) Microsoft Office PowerPoint can't start the application required to
open
this object. An error occurred and this feature is no longer functioning
properly. Would you like to repair this feature now? (The repair function
appears to complete, but does not resolve the problem)
3) There isn't enough memory available to read worksheet.

The same 3 errors occur over and over. I have tried a newer version of
.net
(v2 sp2), I can't think of anything else to try (Office 2003 sp3 cannpt be
uninstalled). Any help would be great as I have 3 divisions trying to do
year end financial presentations for ownership and they are not very happy
that we do not have a solution.
 
M

Mike H

I found a work around. If I save the Excel file as and earlier version (ie.
"Microsoft Excel 97 - Excel 2003 & 5.0/95 Workbook(*.xls)) then I can
successfully paste/edit it within Powerpoint, hopefully this will get my
acounting folks through thier presentations. If you have any other
suggestions, it would be great to have it work without the work around.

Thanks,
Mike

Mike H said:
No luck, none of these resolved the issue. One more observation it appears
to be a visual basic issue as the first error is visual basic based (error
window says Microsoft visual basic) errors 2/3 are powerpoint.

Echo S said:
Try the stuff here:

http://www.pptfaq.com/FAQ00236.htm

re-registering OLE seems to work well lately.

--
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


Mike H said:
We are suddenly unable to paste Excel charts into powerpoint
presentations.
This happens on all 80 + of our workstations. Office 2003 sp3 was
recently
rolled out to all the workstaions and I suspect that this is a result.
All
PC's are Win XP sp3, Office 2003 sp3 fully patched. When they try to
paste a
spreadsheet into a power point or if they try double-click to edit an
Excel
spreadsheet which has been inserted into PowerPoint, they get te following
errors:

1) Error accessing file. Network connection may have been lost.
2) Microsoft Office PowerPoint can't start the application required to
open
this object. An error occurred and this feature is no longer functioning
properly. Would you like to repair this feature now? (The repair function
appears to complete, but does not resolve the problem)
3) There isn't enough memory available to read worksheet.

The same 3 errors occur over and over. I have tried a newer version of
.net
(v2 sp2), I can't think of anything else to try (Office 2003 sp3 cannpt be
uninstalled). Any help would be great as I have 3 divisions trying to do
year end financial presentations for ownership and they are not very happy
that we do not have a solution.
 
E

Echo S

*that* is seriously weird, Mike. Thanks for posting back with the
information.

--
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


Mike H said:
I found a work around. If I save the Excel file as and earlier version
(ie.
"Microsoft Excel 97 - Excel 2003 & 5.0/95 Workbook(*.xls)) then I can
successfully paste/edit it within Powerpoint, hopefully this will get my
acounting folks through thier presentations. If you have any other
suggestions, it would be great to have it work without the work around.

Thanks,
Mike

Mike H said:
No luck, none of these resolved the issue. One more observation it
appears
to be a visual basic issue as the first error is visual basic based
(error
window says Microsoft visual basic) errors 2/3 are powerpoint.

Echo S said:
Try the stuff here:

http://www.pptfaq.com/FAQ00236.htm

re-registering OLE seems to work well lately.

--
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


We are suddenly unable to paste Excel charts into powerpoint
presentations.
This happens on all 80 + of our workstations. Office 2003 sp3 was
recently
rolled out to all the workstaions and I suspect that this is a
result.
All
PC's are Win XP sp3, Office 2003 sp3 fully patched. When they try to
paste a
spreadsheet into a power point or if they try double-click to edit an
Excel
spreadsheet which has been inserted into PowerPoint, they get te
following
errors:

1) Error accessing file. Network connection may have been lost.
2) Microsoft Office PowerPoint can't start the application required
to
open
this object. An error occurred and this feature is no longer
functioning
properly. Would you like to repair this feature now? (The repair
function
appears to complete, but does not resolve the problem)
3) There isn't enough memory available to read worksheet.

The same 3 errors occur over and over. I have tried a newer version
of
.net
(v2 sp2), I can't think of anything else to try (Office 2003 sp3
cannpt be
uninstalled). Any help would be great as I have 3 divisions trying
to do
year end financial presentations for ownership and they are not very
happy
that we do not have a solution.
 
M

Mike H

Alright I found out what happened. Office 2003 sp3 resets macro security on
all powerpoint presentations to "high" when they are opened, blocking the
excel worksheet as excel checks for macros when opening hence the vb error,
so at the end of the day setting the macro security in powerpoint lower
resolves the issue. Not sure why the older ver file format helped. Thanks
for the help Echo.

Mike

Echo S said:
*that* is seriously weird, Mike. Thanks for posting back with the
information.

--
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


Mike H said:
I found a work around. If I save the Excel file as and earlier version
(ie.
"Microsoft Excel 97 - Excel 2003 & 5.0/95 Workbook(*.xls)) then I can
successfully paste/edit it within Powerpoint, hopefully this will get my
acounting folks through thier presentations. If you have any other
suggestions, it would be great to have it work without the work around.

Thanks,
Mike

Mike H said:
No luck, none of these resolved the issue. One more observation it
appears
to be a visual basic issue as the first error is visual basic based
(error
window says Microsoft visual basic) errors 2/3 are powerpoint.

:

Try the stuff here:

http://www.pptfaq.com/FAQ00236.htm

re-registering OLE seems to work well lately.

--
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


We are suddenly unable to paste Excel charts into powerpoint
presentations.
This happens on all 80 + of our workstations. Office 2003 sp3 was
recently
rolled out to all the workstaions and I suspect that this is a
result.
All
PC's are Win XP sp3, Office 2003 sp3 fully patched. When they try to
paste a
spreadsheet into a power point or if they try double-click to edit an
Excel
spreadsheet which has been inserted into PowerPoint, they get te
following
errors:

1) Error accessing file. Network connection may have been lost.
2) Microsoft Office PowerPoint can't start the application required
to
open
this object. An error occurred and this feature is no longer
functioning
properly. Would you like to repair this feature now? (The repair
function
appears to complete, but does not resolve the problem)
3) There isn't enough memory available to read worksheet.

The same 3 errors occur over and over. I have tried a newer version
of
.net
(v2 sp2), I can't think of anything else to try (Office 2003 sp3
cannpt be
uninstalled). Any help would be great as I have 3 divisions trying
to do
year end financial presentations for ownership and they are not very
happy
that we do not have a solution.
 
E

Echo S

This is really bizarre. Thank you so much for posting this information. I'm
sure it will help someone in future.

--
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


Mike H said:
Alright I found out what happened. Office 2003 sp3 resets macro security
on
all powerpoint presentations to "high" when they are opened, blocking the
excel worksheet as excel checks for macros when opening hence the vb
error,
so at the end of the day setting the macro security in powerpoint lower
resolves the issue. Not sure why the older ver file format helped.
Thanks
for the help Echo.

Mike

Echo S said:
*that* is seriously weird, Mike. Thanks for posting back with the
information.

--
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


Mike H said:
I found a work around. If I save the Excel file as and earlier version
(ie.
"Microsoft Excel 97 - Excel 2003 & 5.0/95 Workbook(*.xls)) then I can
successfully paste/edit it within Powerpoint, hopefully this will get
my
acounting folks through thier presentations. If you have any other
suggestions, it would be great to have it work without the work around.

Thanks,
Mike

:

No luck, none of these resolved the issue. One more observation it
appears
to be a visual basic issue as the first error is visual basic based
(error
window says Microsoft visual basic) errors 2/3 are powerpoint.

:

Try the stuff here:

http://www.pptfaq.com/FAQ00236.htm

re-registering OLE seems to work well lately.

--
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


We are suddenly unable to paste Excel charts into powerpoint
presentations.
This happens on all 80 + of our workstations. Office 2003 sp3 was
recently
rolled out to all the workstaions and I suspect that this is a
result.
All
PC's are Win XP sp3, Office 2003 sp3 fully patched. When they try
to
paste a
spreadsheet into a power point or if they try double-click to edit
an
Excel
spreadsheet which has been inserted into PowerPoint, they get te
following
errors:

1) Error accessing file. Network connection may have been lost.
2) Microsoft Office PowerPoint can't start the application
required
to
open
this object. An error occurred and this feature is no longer
functioning
properly. Would you like to repair this feature now? (The repair
function
appears to complete, but does not resolve the problem)
3) There isn't enough memory available to read worksheet.

The same 3 errors occur over and over. I have tried a newer
version
of
.net
(v2 sp2), I can't think of anything else to try (Office 2003 sp3
cannpt be
uninstalled). Any help would be great as I have 3 divisions
trying
to do
year end financial presentations for ownership and they are not
very
happy
that we do not have a solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top