{"id":18778,"date":"2013-05-08T15:52:38","date_gmt":"2013-05-08T10:22:38","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18778"},"modified":"2024-04-12T14:24:23","modified_gmt":"2024-04-12T08:54:23","slug":"managing-data-and-workbooks","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/managing-data-and-workbooks\/","title":{"rendered":"Managing Data and Workbooks"},"content":{"rendered":"

Managing Data and Workbooks<\/strong><\/h4>\n

Use links when you want to maintain information in a single workbook, but also use the information in other workbooks. For example, if your product prices change frequently, you might keep a master price list. 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. When prices change, you only have to enter the new prices in one place.<\/p>\n

\"1\"<\/a><\/p>\n

When you create a link, Excel creates a formula that includes the name of the source workbook in brackets [ ], followed by the worksheet name, an exclamation point, and the cell reference.<\/p>\n

Create links between workbooks<\/span><\/h3>\n
    \n
  1. Open both workbooks.<\/li>\n
  2. In the source workbook, select the cells you want to link to and click the\u00a0Copy\u00a0button.<\/li>\n<\/ol>\n
      \n
    1. Switch to the destination workbook and click the upper left cell of the range where you want the links.<\/li>\n
    2. On the\u00a0Edit\u00a0menu, click\u00a0Paste Special, and then click\u00a0Paste Link.<\/li>\n<\/ol>\n

      You can also create a link starting from the linking workbook. Type an equal sign in a cell, switch to the source workbook, click the cell you want to link to, and then press ENTER.<\/p>\n

      You can copy and autofill linking formulas as you do other Excel formulas.<\/p>\n

      Putting together a set of linked workbooks<\/span><\/h2>\n

      Before you make extensive use of links, it’s a good idea to do some planning. Here are some tips for creating links.<\/p>\n