Updating Linked Data in MS Excel
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 Linked information.
- Choose Yes to update the linked data; or
- Choose No to keep the existing information.
If linked data is not updated when the file is opened, it can be updated manually by using the Edit | Links command.
To update linked data while editing a file, follow the steps below:
- Activate the worksheet that contains the data to be updated.
- Choose Edit | Links.
- The Links dialog box will appear.
- Choose Update Now.
Pretty simple to do isn't it?
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
Free guide: Windows 8 Cheat Sheet: Keyboard Shortcuts. Microsoft Windows has always had some fantastic time-saving keyboard shortcuts designed to make our lives easier. For example: CTRL-X will cut text or objects, and CTRL-V will paste them. (Of course, you can use your mouse to achieve the same thing, but it requires clicking and fumbling through menus, which can be a huge time waster if you cut and paste 50+ times a day). With Windows 8, Microsoft has added many new keyboard shortcuts to their operating system; unfortunately, it's a bit of a learning curve. That's where the Windows 8 keyboard shortcuts cheat sheet comes in! Simply download the guide and reference it when you need to. You'll save a ton of time using your keyboard, rather than reaching for the mouse and flipping through oodles of menus trying to find what you're looking for. Share and enjoy! Click here to download this guide now! Note: this guide is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.