+ Reply to Thread
Results 1 to 1 of 1

Links to Word are slow and unreliable

  1. #1
    Registered User
    Join Date
    09-20-2019
    Location
    New York City
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1

    Links to Word are slow and unreliable

    I have a multi-tab worksheet that feeds a report in Word. The report is long, 37 pages, with multiple links, probably over 100—I never counted them. There are two kinds of links, charts and the results of formulas contained in cells. We created them using paste as link, original formatting. We have gone through several versions of the worksheet-document combination over different versions of office—we’re now using Office 365—and, because, as we added more calculations to the workbook, the Word document began taking longer and longer to load. We decided to break the report into sections. Right now, we have six sections with between 15 and 20 links each. To create the actual report, we paste the contents of the six updated Word documents (the sections) into a new document and then break the links, so that the report remains stable.

    There are two problems. The first is that each of the sections takes between 5-to-10 minutes to load, even if we open it without updating the links. Updating the links takes another 5-to-10-minutes per section. The second is that not all of the links update correctly. What started happening is that instead of updating the calculated cells, the link brings over the cell above it or it will bring over an empty table. As a result we have to spend a great deal of time correcting the final report.

    If we have to, we can live with the amount of time it takes to update the links—I just learned that switching the links to manual update will allow the sections to open quickly although they still take 5-to-10 minutes per section to update once they’re manually updated—but is there any way to ensure that the link update correctly?

    Thanks,

    Henry
    Last edited by hilian; 09-20-2019 at 05:34 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Replace Formula Links-very slow
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-20-2017, 11:03 AM
  2. Extremely slow links problem
    By GJ123 in forum Excel General
    Replies: 0
    Last Post: 05-05-2017, 02:45 AM
  3. Replies: 3
    Last Post: 02-16-2016, 11:41 AM
  4. Links Between Word and Excel affect word performance
    By donk04 in forum Word Formatting & General
    Replies: 2
    Last Post: 06-08-2015, 04:38 AM
  5. Edit Links, values updating very slow
    By 13lack13lade in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2014, 01:38 AM
  6. Replies: 0
    Last Post: 06-23-2010, 01:13 PM
  7. [SOLVED] Opening spreadsheet & word very slow others ok
    By Nokose in forum Excel General
    Replies: 2
    Last Post: 07-18-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1