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?
LVL 17
andrewssd3Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.