#1
|
|||
|
|||
Word linked to Excel
I have a Word file with several links to an Excel file. All of the links within the Word file are set to "Manual Update" rather than "Automatic Update" update. Whenever I open the Word file BEFORE opening the Excel file or WITHOUT opening the Excel file, Word opens/closes the linked Excel file repeatedly as it cycles through all of the links within the Word document. This makes opening the Word file very slow and painful. How can I suppress this function or turn it off?
Thanks |
#2
|
||||
|
||||
I'm not sure if this will make a difference, but make sure Word's 'update automatic links at open' option is unchecked, too.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Yes, it was already unchecked.
|
#4
|
||||
|
||||
AFAIK, if the links are set to manual update, they shouldn't be updating when the Word document is opened - all the more so if the 'update automatic links at open' option is unchecked. That may not apply to links in a page header or footer, though, in which case that may trigger the updating of other links, too.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
So is there any other reason why the Word file would be prompting the opening of the Excel file? Could it have something to do with the different links to Excel? Some links are just a single cell within a sentence, while other links reflect whole tables from Excel. This does not appear to be a HUGE difference in Word, but the link TYPES are slightly different in Word.
Single cell: Excel.SheetMacroEnabled Worksheet Chart: Macro-Enabled Worksheet BTW, what's AFAIK? |
#6
|
||||
|
||||
The kind of content linked to shouldn't matter. The only thing that should matter is auto-updating and, perhaps, whether a link is in the page header/footer.
AFAIK = As Far As I Know (http://www.oxforddictionaries.com/de.../english/AFAIK)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linked excel cells not updating in word | lucky16 | Word | 0 | 09-10-2014 07:40 AM |
Linked Excel file not auto-updating in Word like it should, help needed | Bryan@FIC | Word | 1 | 05-29-2012 07:35 AM |
placing linked Excel cells in Word next to a chart | Paul-NYS | Word | 4 | 03-16-2012 12:59 PM |
Pasting linked Excel pie charts into Word | Paul-NYS | Office | 0 | 07-01-2011 06:56 AM |
Excel File as Linked Object in Word | jfitch | Word | 0 | 03-18-2010 11:44 AM |