Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've two excel file with inside some link to .doc and .pdf file. Both excel files and linked files are on a network shared folder. The first excel file is an .xls, the second an .xlsm.

While opening link to .pdf file is very fast (the file is open in few seconds) it take a long time to open .doc files (about 40 secs.). I have searched on internet but found no solution at the moment.

I have this problem with both excel 2007 and 2010.

Does anyone know how to solve this problem?

Thanks a lot Marco

share|improve this question

migrated from Nov 8 '12 at 8:47

This question came from our site for professional and enthusiast programmers.

Does it take just as long with Word already open and/or the .doc files already open? – pnuts Nov 7 '12 at 15:02
With Word already opened it takes 38 seconds.. not 40 :) – mserioli Nov 7 '12 at 15:11
So @Brian Henry's suggestion may be your best bet - on my stand alone PC a large text file opens via Excel hyperlink in a fraction of a second (with Word not open first). – pnuts Nov 7 '12 at 15:19
Have you considered asking on Server Fault? I fear this link does not provide the answer to your problem but does seem sufficiently similar to justify a question there. – pnuts Nov 7 '12 at 16:15
I try to post my question on Server Fault! Thank you – mserioli Nov 7 '12 at 16:27

Perhaps you can embed the .doc files rather than link them. You'd lose updating from the source docs, but perhaps you'd eliminate the slow update of the linked content. (specifically "Insert a linked object or embedded object from an Excel file")

share|improve this answer
Linked files will be hundreds in a short time.. I prefer to not embed them. Thank you for your response! – mserioli Nov 7 '12 at 15:04
If updating is not a big concern, take local copies off the network first? – pnuts Nov 7 '12 at 15:24
I also want to benefice from updating files.. The link in my situation is the best solution! ..except for the opening latency.. maybe there is a workaround to speedup!! – mserioli Nov 7 '12 at 15:31

It's probably related to your startup add-in. I followed Srinivasu's answer from the link below and the hyperlink works instantaneously. I would imagine there is something built into your add-in. How to fix that I'm not sure.

share|improve this answer
Can you summarize the solution in the body of your answer in case the link goes bad? – jonsca Jul 17 '13 at 22:38

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .