Destination workbook does not auto update when i change the source workbook.

[Legacy 358300]

Hello Mr. Excel,

i have an urgent problem for you to help.
first, i created a main source workbook, and then i linked it with more than 10 destination files.
when i use excel 2010, my destination file will auto update when i change on the main source file although i dont open the file.
However, when i use excel 2013, the file wont update until i open the destination file.
could you please help me on this?

Regards,

Muyleng

 

[Legacy 358300]

Anyone here can give me the answer now? i really need help.

 

[Macropod]

In File|Options|Advanced>When calculating this workbook, have you checked the 'Update links to other workbooks' option? This should be checked.
In File|Options|Advanced>General, have you checked the 'Ignore other applications that use Dynamic Data Exchange (DDE)' option or the 'Ask to update automatic links' option? These should not be checked.

 

[Legacy 358300]

thanks Paul Edstein for ur answer. i already follow ur solution, but the reference link still DOES NOT update. any more solution?

 

[Macropod]

Go to File|Info>Edit Links to Files and check that the links are all set to 'Automatic' Update.

 

[Legacy 358300]

Go to File|Info>Edit Links to Files and check that the links are all set to 'Automatic' Update.

hello, i already tried it, but still cannot update. any other solutions?

 

[Macropod]

Instead of not saying what you've tried until after a suggestion has been posted, how about not wasting our time and tell us instead what you have tried.

Also, have you confirmed that the link paths are exactly the same for Office 2010 and Office 2013?

 

[Legacy 358300]

Instead of not saying what you've tried until after a suggestion has been posted, how about not wasting our time and tell us instead what you have tried.

Also, have you confirmed that the link paths are exactly the same for Office 2010 and Office 2013?

i have tried all what u have mentioned but it still doesnt work. How can i check the link paths to confirm if it the same for office 2010 and office 2013?

 

[Macropod]

Via File|Info>Edit Links to Files. Or you could simply check the formulae doing the external referencing.

 

[Legacy 358300]

Via File|Info>Edit Links to Files. Or you could simply check the formulae doing the external referencing.

could you please advice me on how to check the formulae doing the external referencing?

Regards.