|  | Links to Excel cells no longer found | | |
| | | Tammy |  |
|  Posted: Tue Aug 12, 2008 5:20 pm Post subject: Links to Excel cells no longer found |  |
| |  | |
Hello - I am using PPT 2007 and Excel 2007, and have copied a few Excel cells
to my PPT presentation. I used the Paste Special and Paste Link as a
"Microsoft Office Excel Worksheet Object" options because I need this content
to update in PPT, as the Excel file updates.
When I first performed the copy and paste special, I tested the link by
changing data in Excel - the PPT presentation immediately updated. If I close
the Excel file (saving changes), reopen it, and make changes (I did not close
the PPT file yet)- my PPT presentation does not automatically update, but I
can right-click on the object and update the link. This worked, and the Excel
changes reflected in PPT.
However, once I close PPT (saving changes) and reopen the file, the links
are not found. I get the security warning, choose to update links, and then
receive the warning that some linked files were unavailable and can't be
updated. When I right-click the object and choose Update Link, I get the
warning "The linked file was unavailable and can't be updated."
When I go to Prepare / Edit Links to Files, my Excel worksheet shows as
"unavailable." I choose "Change Source" (the open source button is not
available), reselect my file, the Update column in the Links dialog box
changes to "Automatic" and I close the dialog box. After doing this, I tried
to update the link through the right-click method, but get "The linked file
was unavailable..." message again. Going back to the Links dialog box shows
the link unavailable again.
I have saved the two files in the same folder on a network drive. I cannot
save anything to the hard drive because it's not backed up. No one else has
access to the files except me. I've tried this on two different files with
the same results.
So, it comes down to - what's going on??? It would be a great feature, if it
worked! Is there a process that I'm not following? I'm up for any suggestions!
Thanks! |
| |
| | | Echo S | |
| | Posted: Tue Aug 12, 2008 5:25 pm Post subject: Re: Links to Excel cells no longer found | |
| | | |
Can you try it on your harddrive just as a test? If it works, at least we
know it's a problem with the network paths.
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:24630FB0-6DCF-4D38-8984-C3865BACED98@microsoft.com...
| Quote: | Hello - I am using PPT 2007 and Excel 2007, and have copied a few Excel
cells
to my PPT presentation. I used the Paste Special and Paste Link as a
"Microsoft Office Excel Worksheet Object" options because I need this
content
to update in PPT, as the Excel file updates.
When I first performed the copy and paste special, I tested the link by
changing data in Excel - the PPT presentation immediately updated. If I
close
the Excel file (saving changes), reopen it, and make changes (I did not
close
the PPT file yet)- my PPT presentation does not automatically update, but
I
can right-click on the object and update the link. This worked, and the
Excel
changes reflected in PPT.
However, once I close PPT (saving changes) and reopen the file, the links
are not found. I get the security warning, choose to update links, and
then
receive the warning that some linked files were unavailable and can't be
updated. When I right-click the object and choose Update Link, I get the
warning "The linked file was unavailable and can't be updated."
When I go to Prepare / Edit Links to Files, my Excel worksheet shows as
"unavailable." I choose "Change Source" (the open source button is not
available), reselect my file, the Update column in the Links dialog box
changes to "Automatic" and I close the dialog box. After doing this, I
tried
to update the link through the right-click method, but get "The linked
file
was unavailable..." message again. Going back to the Links dialog box
shows
the link unavailable again.
I have saved the two files in the same folder on a network drive. I cannot
save anything to the hard drive because it's not backed up. No one else
has
access to the files except me. I've tried this on two different files with
the same results.
So, it comes down to - what's going on??? It would be a great feature, if
it
worked! Is there a process that I'm not following? I'm up for any
suggestions!
Thanks!
|
|
| |
| | | Tammy | |
| | Posted: Tue Aug 12, 2008 5:39 pm Post subject: Re: Links to Excel cells no longer found | |
| | | |
Hi Echo,
Thanks so much for your quick reply.
I tested using the harddrive, and the links do work properly. That's
terrific!
Unfortunately, saving to the harddrive is not an option. Is that bad news
for me?
Thanks, again!
"Echo S" wrote:
| Quote: | Can you try it on your harddrive just as a test? If it works, at least we
know it's a problem with the network paths.
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:24630FB0-6DCF-4D38-8984-C3865BACED98@microsoft.com...
Hello - I am using PPT 2007 and Excel 2007, and have copied a few Excel
cells
to my PPT presentation. I used the Paste Special and Paste Link as a
"Microsoft Office Excel Worksheet Object" options because I need this
content
to update in PPT, as the Excel file updates.
When I first performed the copy and paste special, I tested the link by
changing data in Excel - the PPT presentation immediately updated. If I
close
the Excel file (saving changes), reopen it, and make changes (I did not
close
the PPT file yet)- my PPT presentation does not automatically update, but
I
can right-click on the object and update the link. This worked, and the
Excel
changes reflected in PPT.
However, once I close PPT (saving changes) and reopen the file, the links
are not found. I get the security warning, choose to update links, and
then
receive the warning that some linked files were unavailable and can't be
updated. When I right-click the object and choose Update Link, I get the
warning "The linked file was unavailable and can't be updated."
When I go to Prepare / Edit Links to Files, my Excel worksheet shows as
"unavailable." I choose "Change Source" (the open source button is not
available), reselect my file, the Update column in the Links dialog box
changes to "Automatic" and I close the dialog box. After doing this, I
tried
to update the link through the right-click method, but get "The linked
file
was unavailable..." message again. Going back to the Links dialog box
shows
the link unavailable again.
I have saved the two files in the same folder on a network drive. I cannot
save anything to the hard drive because it's not backed up. No one else
has
access to the files except me. I've tried this on two different files with
the same results.
So, it comes down to - what's going on??? It would be a great feature, if
it
worked! Is there a process that I'm not following? I'm up for any
suggestions!
Thanks!
|
|
| |
| | | Echo S | |
| | Posted: Tue Aug 12, 2008 6:05 pm Post subject: Re: Links to Excel cells no longer found | |
| | | |
I'm trying to remember...I think it's a known issue with links to Excel on
network drives, but I'll have to dig some later this evening. Or maybe
someone else will pop in with the info before I get back!
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:AF296A46-6DA7-49FB-8AEB-4828C752F725@microsoft.com...
| Quote: | Hi Echo,
Thanks so much for your quick reply.
I tested using the harddrive, and the links do work properly. That's
terrific!
Unfortunately, saving to the harddrive is not an option. Is that bad news
for me?
Thanks, again!
"Echo S" wrote:
Can you try it on your harddrive just as a test? If it works, at least we
know it's a problem with the network paths.
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:24630FB0-6DCF-4D38-8984-C3865BACED98@microsoft.com...
Hello - I am using PPT 2007 and Excel 2007, and have copied a few Excel
cells
to my PPT presentation. I used the Paste Special and Paste Link as a
"Microsoft Office Excel Worksheet Object" options because I need this
content
to update in PPT, as the Excel file updates.
When I first performed the copy and paste special, I tested the link by
changing data in Excel - the PPT presentation immediately updated. If I
close
the Excel file (saving changes), reopen it, and make changes (I did not
close
the PPT file yet)- my PPT presentation does not automatically update,
but
I
can right-click on the object and update the link. This worked, and the
Excel
changes reflected in PPT.
However, once I close PPT (saving changes) and reopen the file, the
links
are not found. I get the security warning, choose to update links, and
then
receive the warning that some linked files were unavailable and can't
be
updated. When I right-click the object and choose Update Link, I get
the
warning "The linked file was unavailable and can't be updated."
When I go to Prepare / Edit Links to Files, my Excel worksheet shows
as
"unavailable." I choose "Change Source" (the open source button is not
available), reselect my file, the Update column in the Links dialog box
changes to "Automatic" and I close the dialog box. After doing this, I
tried
to update the link through the right-click method, but get "The linked
file
was unavailable..." message again. Going back to the Links dialog box
shows
the link unavailable again.
I have saved the two files in the same folder on a network drive. I
cannot
save anything to the hard drive because it's not backed up. No one else
has
access to the files except me. I've tried this on two different files
with
the same results.
So, it comes down to - what's going on??? It would be a great feature,
if
it
worked! Is there a process that I'm not following? I'm up for any
suggestions!
Thanks!
|
|
| |
| | | Tammy | |
| | Posted: Tue Aug 12, 2008 6:11 pm Post subject: Re: Links to Excel cells no longer found | |
| | | |
Truly appreciate it, Echo! Thanks so much!
"Echo S" wrote:
| Quote: | I'm trying to remember...I think it's a known issue with links to Excel on
network drives, but I'll have to dig some later this evening. Or maybe
someone else will pop in with the info before I get back!
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:AF296A46-6DA7-49FB-8AEB-4828C752F725@microsoft.com...
Hi Echo,
Thanks so much for your quick reply.
I tested using the harddrive, and the links do work properly. That's
terrific!
Unfortunately, saving to the harddrive is not an option. Is that bad news
for me?
Thanks, again!
"Echo S" wrote:
Can you try it on your harddrive just as a test? If it works, at least we
know it's a problem with the network paths.
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:24630FB0-6DCF-4D38-8984-C3865BACED98@microsoft.com...
Hello - I am using PPT 2007 and Excel 2007, and have copied a few Excel
cells
to my PPT presentation. I used the Paste Special and Paste Link as a
"Microsoft Office Excel Worksheet Object" options because I need this
content
to update in PPT, as the Excel file updates.
When I first performed the copy and paste special, I tested the link by
changing data in Excel - the PPT presentation immediately updated. If I
close
the Excel file (saving changes), reopen it, and make changes (I did not
close
the PPT file yet)- my PPT presentation does not automatically update,
but
I
can right-click on the object and update the link. This worked, and the
Excel
changes reflected in PPT.
However, once I close PPT (saving changes) and reopen the file, the
links
are not found. I get the security warning, choose to update links, and
then
receive the warning that some linked files were unavailable and can't
be
updated. When I right-click the object and choose Update Link, I get
the
warning "The linked file was unavailable and can't be updated."
When I go to Prepare / Edit Links to Files, my Excel worksheet shows
as
"unavailable." I choose "Change Source" (the open source button is not
available), reselect my file, the Update column in the Links dialog box
changes to "Automatic" and I close the dialog box. After doing this, I
tried
to update the link through the right-click method, but get "The linked
file
was unavailable..." message again. Going back to the Links dialog box
shows
the link unavailable again.
I have saved the two files in the same folder on a network drive. I
cannot
save anything to the hard drive because it's not backed up. No one else
has
access to the files except me. I've tried this on two different files
with
the same results.
So, it comes down to - what's going on??? It would be a great feature,
if
it
worked! Is there a process that I'm not following? I'm up for any
suggestions!
Thanks!
|
|
| |
| | | Echo S | |
| | Posted: Tue Aug 12, 2008 10:07 pm Post subject: Re: Links to Excel cells no longer found | |
| | | |
Ah, I see Steve's on the case. What he said. :-)
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:299B5E05-AD98-4887-9006-8BB07BEEC427@microsoft.com...
| Quote: | Truly appreciate it, Echo! Thanks so much!
"Echo S" wrote:
I'm trying to remember...I think it's a known issue with links to Excel
on
network drives, but I'll have to dig some later this evening. Or maybe
someone else will pop in with the info before I get back!
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:AF296A46-6DA7-49FB-8AEB-4828C752F725@microsoft.com...
Hi Echo,
Thanks so much for your quick reply.
I tested using the harddrive, and the links do work properly. That's
terrific!
Unfortunately, saving to the harddrive is not an option. Is that bad
news
for me?
Thanks, again!
"Echo S" wrote:
Can you try it on your harddrive just as a test? If it works, at least
we
know it's a problem with the network paths.
--
Echo [MS PPT MVP] LINK
What's new in PPT 2007? LINK
Fixing PowerPoint Annoyances LINK
PowerPoint 2007 Complete Makeover Kit LINK
"Tammy" <Tammy@discussions.microsoft.com> wrote in message
news:24630FB0-6DCF-4D38-8984-C3865BACED98@microsoft.com...
Hello - I am using PPT 2007 and Excel 2007, and have copied a few
Excel
cells
to my PPT presentation. I used the Paste Special and Paste Link as a
"Microsoft Office Excel Worksheet Object" options because I need
this
content
to update in PPT, as the Excel file updates.
When I first performed the copy and paste special, I tested the link
by
changing data in Excel - the PPT presentation immediately updated.
If I
close
the Excel file (saving changes), reopen it, and make changes (I did
not
close
the PPT file yet)- my PPT presentation does not automatically
update,
but
I
can right-click on the object and update the link. This worked, and
the
Excel
changes reflected in PPT.
However, once I close PPT (saving changes) and reopen the file, the
links
are not found. I get the security warning, choose to update links,
and
then
receive the warning that some linked files were unavailable and
can't
be
updated. When I right-click the object and choose Update Link, I get
the
warning "The linked file was unavailable and can't be updated."
When I go to Prepare / Edit Links to Files, my Excel worksheet
shows
as
"unavailable." I choose "Change Source" (the open source button is
not
available), reselect my file, the Update column in the Links dialog
box
changes to "Automatic" and I close the dialog box. After doing this,
I
tried
to update the link through the right-click method, but get "The
linked
file
was unavailable..." message again. Going back to the Links dialog
box
shows
the link unavailable again.
I have saved the two files in the same folder on a network drive. I
cannot
save anything to the hard drive because it's not backed up. No one
else
has
access to the files except me. I've tried this on two different
files
with
the same results.
So, it comes down to - what's going on??? It would be a great
feature,
if
it
worked! Is there a process that I'm not following? I'm up for any
suggestions!
Thanks!
|
|
| |
| | | Steve Rindsberg | |
| | Posted: Tue Aug 12, 2008 10:10 pm Post subject: Re: Links to Excel cells no longer found | |
| | | |
| Quote: | I have saved the two files in the same folder on a network drive. I cannot
save anything to the hard drive because it's not backed up. No one else has
access to the files except me. I've tried this on two different files with
the same results.
So, it comes down to - what's going on??? It would be a great feature, if it
worked! Is there a process that I'm not following? I'm up for any suggestions!
|
The good news: You're not doing anything wrong or expecting anything that PPT
isn't supposed to be able to do.
The bad news: It's a bug. Links to network drives don't seem to work right ...
whether that's in all cases or specific ones, I don't know, but MS is aware of
the problem.
Have a look here though ... I suspect there's a hotfix that'll fix the problem:
PowerPoint 2007 bugs / problems
LINK
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: LINK
PPTools: LINK
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
LINK |
| |
| | | Tammy | |
| | Posted: Wed Aug 13, 2008 11:05 am Post subject: Re: Links to Excel cells no longer found | |
| | | |
Hi Steve and Echo,
Thanks so much for your help and suggestions with this problem. I really
appreciate your time.
Thanks for the link, Steve! It's very helpful (and, nice to know I'm not the
only one who had this problem).
Have a great day! :)
"Steve Rindsberg" wrote:
| Quote: |
I have saved the two files in the same folder on a network drive. I cannot
save anything to the hard drive because it's not backed up. No one else has
access to the files except me. I've tried this on two different files with
the same results.
So, it comes down to - what's going on??? It would be a great feature, if it
worked! Is there a process that I'm not following? I'm up for any suggestions!
The good news: You're not doing anything wrong or expecting anything that PPT
isn't supposed to be able to do.
The bad news: It's a bug. Links to network drives don't seem to work right ...
whether that's in all cases or specific ones, I don't know, but MS is aware of
the problem.
Have a look here though ... I suspect there's a hotfix that'll fix the problem:
PowerPoint 2007 bugs / problems
LINK
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: LINK
PPTools: LINK
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
LINK
|
|
| |
| | | Mel | |
| | Posted: Mon Sep 01, 2008 5:45 am Post subject: Re: Links to Excel cells no longer found | |
Steve, is this known bug applicable only to version 2007? I'm linking
PPT to Excel on a network, but using 2003. Any known issues with
that?
Also, are there any limits to the number of links?
Thanks,
Mel
On Aug 12, 5:10 pm, Steve Rindsberg <ab...@localhost.com> wrote:
| Quote: | The bad news: It's a bug. Links to network drives don't seem to work right ...
whether that's in all cases or specific ones, I don't know, but MS is aware of
the problem.
Have a look here though ... I suspect there's a hotfix that'll fix the problem:
PowerPoint 2007 bugs / LINK
Steve Rindsberg, PPT MVP |
|
| |
| | | Steve Rindsberg | |
| | Posted: Mon Sep 01, 2008 3:56 pm Post subject: Re: Links to Excel cells no longer found | |
| | | |
In article <6f3a4922-c072-4a24-b380-c9316d3eaaef@2g2000hsn.googlegroups.com>, Mel
wrote:
| Quote: | Steve, is this known bug applicable only to version 2007? I'm linking
PPT to Excel on a network, but using 2003.
|
Only 2007 so far as I know.
| Quote: | Also, are there any limits to the number of links?
|
Yes. Links are stored in a common area with other stuff ... about 32kb is allocated
and once that's exceeded, links start to go walkabout.
| Quote: |
Thanks,
Mel
On Aug 12, 5:10 pm, Steve Rindsberg <ab...@localhost.com> wrote:
The bad news: It's a bug. Links to network drives don't seem to work right ...
whether that's in all cases or specific ones, I don't know, but MS is aware of
the problem.
Have a look here though ... I suspect there's a hotfix that'll fix the problem:
PowerPoint 2007 bugs / LINK
Steve Rindsberg, PPT MVP
|
-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: LINK
PPTools: LINK
================================================
Live and in personable in the Help Center at PowerPoint Live
Sept 21-24, San Diego CA, USA
LINK |
| |
| Page 1 of 2 .:. Goto page 1, 2 Next | |
|
|
