…If you open a work book, like this one called Corporate Link, you…might ask yourself, are there any formulas here that get data from other workbooks?…Now, if you're in a working environment where that's not…very common, the question might not even occur to you.…But, lets say that the possibility does exist,…and you might want to know in general.…Does this file have any formulas in it, that gets data from any other workbook?…How do we know?…On the Data tab in the ribbon there's a choice called Edit…Links, if it is selectable, in other words, if it's in black text.…
The pop-up tip, by the way, is slightly off in that it refers to a spreadsheet.…They mean the entire workbook.…View all the other files this, although it doesn't say it, workbook…is linked to so that you can update or remove the links.…So, by clicking edit links when it's selectable.…We are reminded or maybe in this case informed of the…fact that, this workbook has links to Colorado, New Mexico, and Utah.…Now, what this does not mean, is it…does not mean that Colorado has formulas that's getting…
- Explain how to recover a deleted worksheet.
- Identify the purpose of the Protect Workbook command.
- Summarize the steps to view more than one worksheet at the same time.
- Recognize the steps for grouping nonadjacent worksheets.
- Explain the purpose of PivotTables and the Consolidate command.
- Recall the selection that allows users to display the name of all sourced workbooks.