|
![]() |
![]() |
You can link Mesa worksheets so that information from one worksheet can be used in another. The file link is entered into a cell, just like a formula. Mesa's file link syntax is: filename::range or filename!range where filename is the path to the file to be linked. If filename is a path, it must be an absolute path. If it is not a path, Mesa searches for the file in the directory where current worksheet is saved. Filename can either be a string or a cell reference. This allows you to link to different worksheets based on the contents of a cell Range can be a cell address, range, or label. If both files are in the same directory, you can use just the filename. Otherwise, you must specify the path of the linked file. Linked Workbook Examples Formula Result =Sales::A1 Returns contents of cell A1 in worksheet ªSalesº located in the same directory as the current worksheet. =/sam/Sales.Mesa::c5 Prices Returns the contents of cell C5 in the ª/sam/Salesº worksheet. =sum(Sales!a1:b7) Returns the sum of cells A1 through B7 in the Sales worksheet located in the same directory as the current worksheet. =sum(Sales::Western) Returns the sum of the cells in the range Western in the Sales worksheet located in the same directory as the current worksheet. =X1::A1 Returns the contents of cell A1 in the worksheet whose name is contained in cell X1. =sum(X1::widgets) Returns the sum of the ªwidgetsº range in the worksheet whose name is contained in cell X1. Note that the MAC OS X environment is sensitive to capital letters in file names, so be sure to spell file names exactly as you see them. File names may contain spaces, which must be included in link references as well. When you work with linked files, be aware of the following points: When you open a worksheet that has links, recalculate using Apple-= unless Auto Recalc is on. Links can be used in formulas, just like any other valid expression. For example: @PV(2500,4%, "US_SALES"::b5). Referencing files via cells (i.e., Q5::Prices) is a powerful tool that allows changing where the data for a calculation is coming from without changing the formula. If you have sales data from four regions saved in worksheets named, North, South, East, and West, you could build a summary worksheet to generate totals for each region. The formula =sum(b5::total_sales) would sum the total_sales region for the sheet named in cell B5. To see the summary for North, enter "North" into cell B5 and select Sheet -> Recalculate (Apple-=). To see the summary for West, enter "West" into cell B5 and select Sheet -> Recalculate. |
||
|
||