Update Links - Excel to Word

[ligerdub]

Hello all,

I understand this may be a common problem, but after searching for quite a while I am no nearer in finding a solution, so any help at all would be gratefully received.

What I have is a large Excel file, which contains the bulk of the data used to generate a report for clients. This report will be in Word format.

At present I have about 50 cells from the Excel file which are linked to points in the Word document. Word takes the value from the Excel file, and updates automatically. This is all fine.

The problem I have is that it takes around 2 minutes from clicking the button which generates the Word doc/report to when the links have been fully updated. Does anyone know of the best way to speed this process up as quickly as I possibly can? I will use any VBA approach required if this is the best method to achieve this.

Many thanks.

[macropod]

Well, yes, you could do much the same with vba and I expect it would take rather less than two minutes. However, whether the problem is due to the way Word is updating the links, is due to an installation error, a 3rd-party addin or OS factors (eg linking across a network or the use of sharepoint) isn't something we can resolve from the details you've provided. If it's a network issue, that's just as likely to impact a macro solution too. FWIW, I don't have problems with links on a stand-alone PC.

[ligerdub]

Thanks for the reply.

The related files are indeed on a shared network. Perhaps I'll just have to accept defeat on this one.