Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
    
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
add comment

migrated from stackoverflow.com Nov 8 '12 at 8:47

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

2 Answers

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.

http://office.microsoft.com/en-us/word-help/link-or-embed-an-excel-worksheet-HA010120810.aspx (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
add comment

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.

http://answers.microsoft.com/en-us/office/forum/office_2010-word/why-is-the-insert-hyperlink-dialog-taking-so-long/45cca6a5-4091-4c39-862e-3df164a7a8b0

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.