Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 429
  • Last Modified:

Powerpoint Excel links update issues

One of my users has a large PPT presentation that has multiple OLE links to chart objects and cells in 8 different Excel workbooks.  There are many different links to each workbook.  She reports that in the Links update dialog she used to see just the 8 workbooks (I'm not sure I believe this, but she could be right), and colud update them easily.  Now each individual link shows up in the dialog box.

When updating the links either from the dialog box or when opening the file, PPT now seems to be opening each file visibly in Excel and closing it again for each link, not just for each file.  This naturally takes forever.  She sometimes also gets the message 'File is unavailable and cannot be updated' when selecting just one link for update (all the linked Excel files definitely exist).

I don't think anything in the environment has changed, and the user claims no changes to have been made to her presentation or the linked Excel files. Any ideas?
0
andrewssd3
Asked:
andrewssd3
  • 4
1 Solution
 
andrewssd3Author Commented:
PPT and Excel 2007
0
 
andrewssd3Author Commented:
Added Excel zone to this in case any of you Excel experts has seen anything similar, and the PPT Zone is eerily silent.
0
 
Michael FowlerSolutions ConsultantCommented:
Since no one else has jumped in my suggestion is

1/ First investigate which links are really required and remove the rest
2/ Delete and recreate these links

Michael
0
 
andrewssd3Author Commented:
Thanks for responding - I am already doing that as a workaround, but I was really wondering if anyone could explain why this behaviour might have changed.
0
 
andrewssd3Author Commented:
I haven't really got the sort of answer I wanted, but thanks for participating - I'm getting fed up with looking at this at the top of my list all the time!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now