A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Accessing an embedded Excel object from a PowerPoint Presentation



 
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2004, 05:12 PM
Jeremy
external usenet poster
 
Posts: n/a
Default Accessing an embedded Excel object from a PowerPoint Presentation

Hello All,

I originally discovered this problem while working on an
Office Automation project, but the same issues appear in
the UI, so here's the symptoms:

I'm having difficulty accessing an embedded Excel
spreadsheet from a PowerPoint document, and I can't insert
an embedded Excel spreadsheet into a new PowerPoint
presentation. I can't seem to find an answer to this
problem anywhere. I'm using Office XP SP3 on a Windows
2000 SP4 system with all the latest patches installed (for
both Win2K and Office XP), and no, I don't have Norton
AntiVirus or SystemWorks installed.

From an existing PPT document with an embedded Excel
spreadsheet:
If I right-click on the spreadsheet -- select "Linked
Worksheet Object" -- and attempt to click either "Open"
or "Edit", I receive the following error-
"Microsoft 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?" "Yes" or "No" are my options to continue.

If I select "Yes", another dialog box opens that
says: "Installing: Application Server" with a progress bar
and a cancel button. Eventually, this process fails with
the error-
"The server application, source file, or item can't be
found, or returned with an unkown error. You may need to
reinstall the server application." This error also
occurrs if I select the "No" button.

If I select "Update Link" from the right-click context
menu, I receive the error-
"The linked file was unavailable and can't be updated."
with an "OK" button to continue.

From either an existing PPT document with embedded Excel
spreadsheets, or from a new blank PPT document, if I
select the "Insert" menu -- then "Object" -- "Create
from file" -- "Browse" -- (select any XL file here) --
check the "Link" box -- and click the "OK" button, I
receive the same error as above-
"The server application, source file, or item can't be
found, or returned with an unkown error. You may need to
reinstall the server application."

I don't have any Norton products installed.
I've tried saving the file in an older format (97-2002,
95) and then modifying the file.
I've tried both repairing and reinstalling Office.
I've tried re-registering MS Graph, as well as MS Excel
and MS PowerPoint (the last two were just for kicks) using
the Office path\program name /regserver syntax.
I've tried using a path with less than 64 total characters.
I don't have a folder in either the root or Program Files
folders named either "Microsoft" or "Program" (and as I
mentioned before, I'm not running Win NT 4.0).
I'm not linking to an Org chart, just trying to link to an
Excel spreadsheet.

At this point, I'm thinking the problem lies in the fact
that the PPT file with the original problem was created in
either Office 97 or Office 95. I can replicate the same
problem using the same file across 4 machines.

Machine 1 (original, mentioned above):
Win2K Pro SP4, Office XP SP3 (upgraded from Office 97)
with all patches from windowsupdate and officeupdate
installed. This problem is replicated using either the
original problem PPT file, or attempting to insert an
Excel spreadsheet into a blank PPT file. I had also
attempted installing the PowerPoint Viewer, to see if by
chance this would re-register some missing components.
Didn't work.

Machine 2
Win2K Server SP4, Office XP SP3 (clean install) with all
patches from windowsupdate and officeupdate installed.
This problem is replicated using either the original
problem PPT file, or attempting to insert an Excel
spreadsheet into a blank PPT file.

Machine 3
Win2K Pro SP4, Office 97 SR2, appears to be missing most
OS updates after SP4. This problem is replicated using
either the original problem PPT file, but I can insert an
Excel 97 spreadsheet into a blank PPT 97 file. I had also
attempted installing the PowerPoint Viewer, to see if by
chance this would re-register some missing components to
re-enable the original problem file. Didn't work.

Machine 4
A near-duplicate of Machine 3, except I didn't attempt
installing the PowerPoint Viewer on this system. Same
results as Machine 3.

I've thoroughly searched Google for help with this... but
to no avail. Hope someone can help...

Thanks in advance,
-Jeremy
  #2  
Old September 27th, 2004, 07:45 PM
Jeremy
external usenet poster
 
Posts: n/a
Default

BTW, all linked files are available. I can open the file
path that appears in the "Edit" -- "Links" area using
Excel as a standalone application.

It appears to me that this is is a bug in Office XP SP3
that requires another patch. All OLE linking appears to
have been disabled with the latest patches. Office 97 and
Office 2000 work fine.

I don't have confirmation from Microsoft regarding this
assessment, however.

My workaround for my particular situation:
1.) Re-construct the original file using Office 2000
(relative paths work only intermittently on our Novell
network when using Office 97).
2.) Update links and perform any other modifications as
desired using Office Automation.
3.) Save a copy of the original file and display the copy
to the client.
4.) NEVER overwrite the original file by saving it using
Office XP SP3. Doing so will corrupt all existing links
in the PPT file.

So, how do I report this as a bug?

-Jeremy


-----Original Message-----
Hello All,

I originally discovered this problem while working on an
Office Automation project, but the same issues appear in
the UI, so here's the symptoms:

I'm having difficulty accessing an embedded Excel
spreadsheet from a PowerPoint document, and I can't

insert
an embedded Excel spreadsheet into a new PowerPoint
presentation. I can't seem to find an answer to this
problem anywhere. I'm using Office XP SP3 on a Windows
2000 SP4 system with all the latest patches installed

(for
both Win2K and Office XP), and no, I don't have Norton
AntiVirus or SystemWorks installed.

From an existing PPT document with an embedded Excel
spreadsheet:
If I right-click on the spreadsheet -- select "Linked
Worksheet Object" -- and attempt to click either "Open"
or "Edit", I receive the following error-
"Microsoft 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?" "Yes" or "No" are my options to continue.

If I select "Yes", another dialog box opens that
says: "Installing: Application Server" with a progress

bar
and a cancel button. Eventually, this process fails with
the error-
"The server application, source file, or item can't be
found, or returned with an unkown error. You may need to
reinstall the server application." This error also
occurrs if I select the "No" button.

If I select "Update Link" from the right-click context
menu, I receive the error-
"The linked file was unavailable and can't be updated."
with an "OK" button to continue.

From either an existing PPT document with embedded Excel
spreadsheets, or from a new blank PPT document, if I
select the "Insert" menu -- then "Object" -- "Create
from file" -- "Browse" -- (select any XL file here) --
check the "Link" box -- and click the "OK" button, I
receive the same error as above-
"The server application, source file, or item can't be
found, or returned with an unkown error. You may need to
reinstall the server application."

I don't have any Norton products installed.
I've tried saving the file in an older format (97-2002,
95) and then modifying the file.
I've tried both repairing and reinstalling Office.
I've tried re-registering MS Graph, as well as MS Excel
and MS PowerPoint (the last two were just for kicks)

using
the Office path\program name /regserver syntax.
I've tried using a path with less than 64 total

characters.
I don't have a folder in either the root or Program Files
folders named either "Microsoft" or "Program" (and as I
mentioned before, I'm not running Win NT 4.0).
I'm not linking to an Org chart, just trying to link to

an
Excel spreadsheet.

At this point, I'm thinking the problem lies in the fact
that the PPT file with the original problem was created

in
either Office 97 or Office 95. I can replicate the same
problem using the same file across 4 machines.

Machine 1 (original, mentioned above):
Win2K Pro SP4, Office XP SP3 (upgraded from Office 97)
with all patches from windowsupdate and officeupdate
installed. This problem is replicated using either the
original problem PPT file, or attempting to insert an
Excel spreadsheet into a blank PPT file. I had also
attempted installing the PowerPoint Viewer, to see if by
chance this would re-register some missing components.
Didn't work.

Machine 2
Win2K Server SP4, Office XP SP3 (clean install) with all
patches from windowsupdate and officeupdate installed.
This problem is replicated using either the original
problem PPT file, or attempting to insert an Excel
spreadsheet into a blank PPT file.

Machine 3
Win2K Pro SP4, Office 97 SR2, appears to be missing most
OS updates after SP4. This problem is replicated using
either the original problem PPT file, but I can insert an
Excel 97 spreadsheet into a blank PPT 97 file. I had

also
attempted installing the PowerPoint Viewer, to see if by
chance this would re-register some missing components to
re-enable the original problem file. Didn't work.

Machine 4
A near-duplicate of Machine 3, except I didn't attempt
installing the PowerPoint Viewer on this system. Same
results as Machine 3.

I've thoroughly searched Google for help with this... but
to no avail. Hope someone can help...

Thanks in advance,
-Jeremy
.

  #3  
Old September 27th, 2004, 08:27 PM
garfield-n-odie
external usenet poster
 
Posts: n/a
Default

Disable the Office Plugin that comes with Symantec/Norton AntiVirus. See
http://support.microsoft.com/?kbid=329820 "How to use Office programs
with the Norton AntiVirus Office plug-in" for more info.

Jeremy wrote:

Hello All,

I originally discovered this problem while working on an
Office Automation project, but the same issues appear in
the UI, so here's the symptoms:

I'm having difficulty accessing an embedded Excel
spreadsheet from a PowerPoint document, and I can't insert
an embedded Excel spreadsheet into a new PowerPoint
presentation. I can't seem to find an answer to this
problem anywhere. I'm using Office XP SP3 on a Windows
2000 SP4 system with all the latest patches installed (for
both Win2K and Office XP), and no, I don't have Norton
AntiVirus or SystemWorks installed.

From an existing PPT document with an embedded Excel
spreadsheet:
If I right-click on the spreadsheet -- select "Linked
Worksheet Object" -- and attempt to click either "Open"
or "Edit", I receive the following error-
"Microsoft 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?" "Yes" or "No" are my options to continue.

If I select "Yes", another dialog box opens that
says: "Installing: Application Server" with a progress bar
and a cancel button. Eventually, this process fails with
the error-
"The server application, source file, or item can't be
found, or returned with an unkown error. You may need to
reinstall the server application." This error also
occurrs if I select the "No" button.

If I select "Update Link" from the right-click context
menu, I receive the error-
"The linked file was unavailable and can't be updated."
with an "OK" button to continue.

From either an existing PPT document with embedded Excel
spreadsheets, or from a new blank PPT document, if I
select the "Insert" menu -- then "Object" -- "Create
from file" -- "Browse" -- (select any XL file here) --
check the "Link" box -- and click the "OK" button, I
receive the same error as above-
"The server application, source file, or item can't be
found, or returned with an unkown error. You may need to
reinstall the server application."

I don't have any Norton products installed.
I've tried saving the file in an older format (97-2002,
95) and then modifying the file.
I've tried both repairing and reinstalling Office.
I've tried re-registering MS Graph, as well as MS Excel
and MS PowerPoint (the last two were just for kicks) using
the Office path\program name /regserver syntax.
I've tried using a path with less than 64 total characters.
I don't have a folder in either the root or Program Files
folders named either "Microsoft" or "Program" (and as I
mentioned before, I'm not running Win NT 4.0).
I'm not linking to an Org chart, just trying to link to an
Excel spreadsheet.

At this point, I'm thinking the problem lies in the fact
that the PPT file with the original problem was created in
either Office 97 or Office 95. I can replicate the same
problem using the same file across 4 machines.

Machine 1 (original, mentioned above):
Win2K Pro SP4, Office XP SP3 (upgraded from Office 97)
with all patches from windowsupdate and officeupdate
installed. This problem is replicated using either the
original problem PPT file, or attempting to insert an
Excel spreadsheet into a blank PPT file. I had also
attempted installing the PowerPoint Viewer, to see if by
chance this would re-register some missing components.
Didn't work.

Machine 2
Win2K Server SP4, Office XP SP3 (clean install) with all
patches from windowsupdate and officeupdate installed.
This problem is replicated using either the original
problem PPT file, or attempting to insert an Excel
spreadsheet into a blank PPT file.

Machine 3
Win2K Pro SP4, Office 97 SR2, appears to be missing most
OS updates after SP4. This problem is replicated using
either the original problem PPT file, but I can insert an
Excel 97 spreadsheet into a blank PPT 97 file. I had also
attempted installing the PowerPoint Viewer, to see if by
chance this would re-register some missing components to
re-enable the original problem file. Didn't work.

Machine 4
A near-duplicate of Machine 3, except I didn't attempt
installing the PowerPoint Viewer on this system. Same
results as Machine 3.

I've thoroughly searched Google for help with this... but
to no avail. Hope someone can help...

Thanks in advance,
-Jeremy


  #4  
Old September 28th, 2004, 06:40 PM
Jeremy
external usenet poster
 
Posts: n/a
Default

I don't have any Norton products installed. It's not a
Norton AntiVirus issue. I even checked to make sure that
there is no network Norton scanning taking place.

Thanks for the help, but this is an Office XP issue.

-Jeremy

-----Original Message-----
Disable the Office Plugin that comes with Symantec/Norton

AntiVirus. See
http://support.microsoft.com/?kbid=329820 "How to use

Office programs
with the Norton AntiVirus Office plug-in" for more info.

Jeremy wrote:

Hello All,

I originally discovered this problem while working on

an
Office Automation project, but the same issues appear

in
the UI, so here's the symptoms:

I'm having difficulty accessing an embedded Excel
spreadsheet from a PowerPoint document, and I can't

insert
an embedded Excel spreadsheet into a new PowerPoint
presentation. I can't seem to find an answer to this
problem anywhere. I'm using Office XP SP3 on a Windows
2000 SP4 system with all the latest patches installed

(for
both Win2K and Office XP), and no, I don't have Norton
AntiVirus or SystemWorks installed.

From an existing PPT document with an embedded Excel
spreadsheet:
If I right-click on the spreadsheet -- select "Linked
Worksheet Object" -- and attempt to click

either "Open"
or "Edit", I receive the following error-
"Microsoft 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?" "Yes" or "No" are my options to continue.

If I select "Yes", another dialog box opens that
says: "Installing: Application Server" with a progress

bar
and a cancel button. Eventually, this process fails

with
the error-
"The server application, source file, or item can't be
found, or returned with an unkown error. You may need

to
reinstall the server application." This error also
occurrs if I select the "No" button.

If I select "Update Link" from the right-click context
menu, I receive the error-
"The linked file was unavailable and can't be updated."
with an "OK" button to continue.

From either an existing PPT document with embedded

Excel
spreadsheets, or from a new blank PPT document, if I
select the "Insert" menu -- then "Object" -- "Create
from file" -- "Browse" -- (select any XL file here) --


check the "Link" box -- and click the "OK" button, I
receive the same error as above-
"The server application, source file, or item can't be
found, or returned with an unkown error. You may need

to
reinstall the server application."

I don't have any Norton products installed.
I've tried saving the file in an older format (97-2002,
95) and then modifying the file.
I've tried both repairing and reinstalling Office.
I've tried re-registering MS Graph, as well as MS Excel
and MS PowerPoint (the last two were just for kicks)

using
the Office path\program name /regserver syntax.
I've tried using a path with less than 64 total

characters.
I don't have a folder in either the root or Program

Files
folders named either "Microsoft" or "Program" (and as I
mentioned before, I'm not running Win NT 4.0).
I'm not linking to an Org chart, just trying to link to

an
Excel spreadsheet.

At this point, I'm thinking the problem lies in the

fact
that the PPT file with the original problem was created

in
either Office 97 or Office 95. I can replicate the

same
problem using the same file across 4 machines.

Machine 1 (original, mentioned above):
Win2K Pro SP4, Office XP SP3 (upgraded from Office 97)
with all patches from windowsupdate and officeupdate
installed. This problem is replicated using either the
original problem PPT file, or attempting to insert an
Excel spreadsheet into a blank PPT file. I had also
attempted installing the PowerPoint Viewer, to see if

by
chance this would re-register some missing components.
Didn't work.

Machine 2
Win2K Server SP4, Office XP SP3 (clean install) with

all
patches from windowsupdate and officeupdate installed.
This problem is replicated using either the original
problem PPT file, or attempting to insert an Excel
spreadsheet into a blank PPT file.

Machine 3
Win2K Pro SP4, Office 97 SR2, appears to be missing

most
OS updates after SP4. This problem is replicated using
either the original problem PPT file, but I can insert

an
Excel 97 spreadsheet into a blank PPT 97 file. I had

also
attempted installing the PowerPoint Viewer, to see if

by
chance this would re-register some missing components

to
re-enable the original problem file. Didn't work.

Machine 4
A near-duplicate of Machine 3, except I didn't attempt
installing the PowerPoint Viewer on this system. Same
results as Machine 3.

I've thoroughly searched Google for help with this...

but
to no avail. Hope someone can help...

Thanks in advance,
-Jeremy


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Several Charts to a PowerPoint Presentation JRPK Links and Linking 3 April 2nd, 2005 10:02 PM
linking a multiple paged Excel spreadsheet in PowerPoint Kris Powerpoint 1 September 1st, 2004 08:00 PM
Export data from OLE object in PowerPoint Brett Ellingson Powerpoint 8 August 25th, 2004 12:28 AM
PowerPoint Presentation will not load Bowdrie Powerpoint 10 July 6th, 2004 09:40 PM
can't launch Powerpoint 2004 for mac Scott Powerpoint 2 May 23rd, 2004 07:14 PM


All times are GMT +1. The time now is 11:07 AM.


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