Excel Tips, Tricks, and Shortcuts

Hello there. I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about how to solve the Excel problem like as follows: The Excel Worksheet display "This Workbook Contains Links To Other Data Sources" When opening an Excel file. Have you ever been annoyed by the message? " This workbook contains links to other data sources. If you update the links, Excel will attempt to retrieve the latest data. If you don't update the links, Excel will use the previous information.  Note that data links can be used to access and share confidential information without your permission and possibly perform other harmful actions. Do not update the links if you don't trust the source of this workbook. " Tip Quiz Do you know what is the shortcut for filling cell formula down from the adjacent cell above? Hereafter steps to do: 1) Select the "Data Tab" on the ribbon. 2) Click on "Edit Links...