linked data

Let's get back on track with our series on linked data in Excel! Source data that is referenced within the same workbook is updated automatically. However, when source data is stored in a separate workbook file, you can decide when the update should ... occur. By default, you will be prompted to update the data when the file is opened. Data can be updated as the file is being opened or after the file is in use. To update linked data when opening a file, follow the steps below: Open the workbook that contains the external cell reference(s). You will see a Message box asking whether to update ... (view more)