![]() ![]() ![]() ![]() When prices change, you only have to enter the new prices in one place. Other workbooks that use the price data in calculations, such as purchase orders, inventory valuations, or sales estimates, can create links to the price list workbook so calculations always use current prices. For example, if your product prices change frequently, you might keep a master price list. Use links when you want to maintain information in a single workbook, but also use the information in other workbooks. When you open a workbook that contains links (a linking workbook), Microsoft Excel reads in the latest data from the source workbook or workbooks (updates the links). ![]() A link is a formula that gets data from a cell in another workbook. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |