Share via

Automatic Update Link between excel and word

Anonymous
2010-12-07T23:58:22+00:00

I just updated to 2010 Office. I have some links between excel and word and they no longer will update automatically even though I have it set to. The old version was 2003. What can I do to get them to auto update. I have to now right click and select update for anything to update.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-12-08T01:40:24+00:00
  • In Word, try hovering the mousepointer over the linked spreadsheet table,
  • right click,
  • select "Link macro enabled Worksheet Object" ,
  • select Links ... , to display the Links dialog.
  • Check that the "Update Method for selected link" is set to "Automatic Update"

If this proposed solution has resolved your issue(s), please mark it as  Propose as Answer  to let others know the solution that worked for you

Please click on the  "Vote as Helpful" button!

http://office.microsoft.com/en-us/outlook-help/learn-where-menu-and-toolbar-commands-are-in-office-2010-HA101794130.aspx - Silverlight applets Mapping 2003 to 2010 commands for all Office apps.

http://office.microsoft.com/en-us/training/HA102295841033.aspx - flash applets mapping Office 2003 menus to 2007 ribbon.

Was this answer helpful?

7 people found this answer helpful.
0 comments

21 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Paul Edstein 82,861 Reputation points Volunteer Moderator
    2015-10-12T21:16:54+00:00

    There is a much simpler and faster way for most documents:

    1. Open the document
    2. Press Alt-F9 to expose the field codes, which will look something like

    {LINK Excel.Sheet.12 "C:\Users\Usename\Documents\SomePath\ExcelWorkbook.xlsx" "Sheet1!R1C1:R2C2" \a \p }

    1. Use Find/Repalce to update however much of the path & name needs changing
    2. Press Alt-F9 to hide the field codes
    3. Press Ctrl-A, F9 to update the links.

    If the new files have the same relative path as the old ones (e.g. they're saved in a single folder), you can use

    the macro solution I've posted at:

    http://windowssecrets.com/forums/showthread.php/154379-Word-Fields-and-Relative-Paths-to-External-Files

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2014-12-27T03:04:05+00:00

    Having the same exact problem, any other solutions?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2014-12-01T22:23:34+00:00

    Hi

    Save Both Of Excel & Word on " Word Macro - Enabled Template "

    Your Path Is :

    File Tab - Save As - Computer & Press on Browse Then Save as type must be " Word Macro - Enabled Template "

    Good Luck.

    Nakhforoosh

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2012-05-16T06:36:21+00:00
    • In Word, try hovering the mousepointer over the linked spreadsheet table,
    • right click,
    • select "Link macro enabled Worksheet Object" ,
    • select Links ... , to display the Links dialog.
    • Check that the "Update Method for selected link" is set to "Automatic Update"

    If this proposed solution has resolved your issue(s), please mark it as  Propose as Answer  to let others know the solution that worked for you

    Please click on the  "Vote as Helpful" button!

    http://office.microsoft.com/en-us/outlook-help/learn-where-menu-and-toolbar-commands-are-in-office-2010-HA101794130.aspx - Silverlight applets Mapping 2003 to 2010 commands for all Office apps.

    http://office.microsoft.com/en-us/training/HA102295841033.aspx - flash applets mapping Office 2003 menus to 2007 ribbon.

    Sorry, that was not my problem

    Was this answer helpful?

    0 comments