Excel – Hyperlink to doc file slow opening

microsoft excelmicrosoft-excel-2007microsoft-excel-2010

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

Best Answer

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")

Related Solutions

Excel – How to change the default program to open Excel files with from Excel 2010 to Excel 2007

You don't say what OS you have, so your mileage may vary. On XP, the usual way used to be from the command line:

<path to version which is current default eg Office14>\excel.exe /unregserver
<path to version which is desired default eg Office12>\excel.exe /regserver

However, on my Win7 system this makes no difference. (like you I have 2003, 2007 and 2010 installed, 2007 is default for me and does not change with above commands, run as user and as admin) Next best option usually is control panel > programs > add/remove (again exact route depends on your OS here) > choose the Office install you want and do a change > repair on it. This can take a while, but I just did it on 2010 and it worked, this is now my default.

With the benefit of hindsight, install the one you want to be default last, repair effectively winds back the clock and installs a previous one again, making it "last".

(have to go run it on 2007 now since that is what I really want to be default for Excel at the moment since I am teaching some courses on it next week)

Excel 2010 Starts with a grey screen, won’t open file

This issue has more to do with Excel 2010 than anything else. It started in July after a big security update thru Windows Update. Here is an article to back that up - Excel refusing to open files? Blame the KB 3115322, 3115262 security updates.

I started having the issue you described when downloading reports via the Internet. After many frustrating hours, I was able to get Excel to open them with a bit of a work around.

WARNING: Only do this if you trust the origin of the files.

Open the Trust Center.
Go to Protected View.
Deselect the box for Enable Protected View for files originating from the Internet.

When you open one of these files you will get a warning message.

If you click Yes, it will open the file. You can then save the file in the proper format for future work.

Best Answer

Related Solutions

Excel – How to change the default program to open Excel files with from Excel 2010 to Excel 2007

Excel 2010 Starts with a grey screen, won’t open file

Related Question