I have recently moved from Office 2007 to office 2010. In our office we regularly results from Excel worksheets to our final reports written in Word. At the end of a 40 page report we will have roughly 40 excel links to three individual excel files. These are saved as links since the results are iterative as the report changes based on the design of the project. When I copy this link link in it has begun hanging for 30 seconds. Then when ever I click on the object again it hangs again. Has anyone else experienced this in 2010?
Solutions I've thought of are below
-- Determine a way for the links to be added and automatically set to UpdateMode = OnCall, not Always
-- Move away from links and figure out a way to automatically refresh images held in word.
Do you guys have any other thoughts or solutions?