Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2012, 09:35 AM
joatmon joatmon is offline Stop Automatic Updating of Links from Excel Windows 7 64bit Stop Automatic Updating of Links from Excel Office 2010 64bit
Novice
Stop Automatic Updating of Links from Excel
 
Join Date: May 2012
Posts: 14
joatmon is on a distinguished road
Default Stop Automatic Updating of Links from Excel


I have a large Excel file and a Word file that contains many links that pull data from this Excel file. Every time I make a small change in the Excel file, the Word file brings things to a halt for quite a few seconds as it updates all of the links. Is there any way that I can change Word so that it only updates the links when I tell it to, rather than automatically updating the links continuously?
Reply With Quote
  #2  
Old 05-31-2012, 05:58 PM
macropod's Avatar
macropod macropod is offline Stop Automatic Updating of Links from Excel Windows 7 64bit Stop Automatic Updating of Links from Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can change the links to manual update. There are various ways of doing this, including:
• Add the 'update links' function to the QAT, then use that to change the links from automatic to manual;
• Edit the LINK field codes to remove the '\a' switch (use Alt-F9 to toggle the field code display for editing); or
• Lock the linked content via Ctrl-F11 (Ctrl-Shift-F11 to unlock).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-31-2012, 06:04 PM
joatmon joatmon is offline Stop Automatic Updating of Links from Excel Windows 7 64bit Stop Automatic Updating of Links from Excel Office 2010 64bit
Novice
Stop Automatic Updating of Links from Excel
 
Join Date: May 2012
Posts: 14
joatmon is on a distinguished road
Default

Excellent suggestions. Thank you very much!
Reply With Quote
  #4  
Old 05-31-2012, 09:04 PM
Kimberlywhite Kimberlywhite is offline Stop Automatic Updating of Links from Excel Windows XP Stop Automatic Updating of Links from Excel Office 2010 32bit
Novice
 
Join Date: May 2012
Posts: 1
Kimberlywhite is on a distinguished road
Default links

I have had the same problem and wasnt able to fix it, if somebody knows it would be great help!
Reply With Quote
  #5  
Old 05-31-2012, 10:54 PM
macropod's Avatar
macropod macropod is offline Stop Automatic Updating of Links from Excel Windows 7 64bit Stop Automatic Updating of Links from Excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Kimberlywhite,

Did you read the advice given earlier in this thread? It tells you how!!!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop Automatic Updating of Links from Excel Can you stop Cross References from Updating Automatically? Welshie82 Word 2 05-14-2012 02:10 AM
Turning off automatic links to Excel charts Erdvige PowerPoint 4 04-26-2012 09:30 AM
Updating Links johnp Word 0 10-18-2011 03:36 PM
Stop Automatic Updating of Links from Excel Stop Automatic Slide Transition pgr380 PowerPoint 5 03-25-2011 07:11 PM
Updating Excel Chart Links fermat PowerPoint 0 07-09-2010 04:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft