Excel Options), in the Excel Options dialog box, click Advanced in the left pane, and then uncheck Ask to update automatic links under General section, see screenshot:2.Then click OK to close this dialog, when you open this workbook next time, the links are automatically updated, and additionally, no message appears.The default option, "Let users choose..." uses the current user's setting, which by default displays an update prompt each time you open the workbook.Close all open dialog boxes and select a linked cell to verify that its formula points to the updated source workbook.
Because it is a Power Point object, it will be consistent with the organization branding standards.
You probably arrived at this page because you are a business professional who has to present regularly to management or executives on analysis you have done in Excel.
You don’t want to have to retype a table of numbers or recreate a graph in Power Point.
Submit a question Do you have technology questions for this column?
Or, after reading an answer, do you have a better solution? We regret being unable to individually answer all submitted questions.
This solution works fairly well except that when our employees keep their workbooks open for extended periods of time, they occasionally forget to update their links and end up making decisions based on obsolete data.