Are there anyother was to link formulas?

Hiya Ben

Hope you are well, the two ways that we did in the class, where by clicking the places in the file or files that are open, that look like the example below

=b4+sheet2!h5,[test.xls]sheet3!d5

and the other type was by using the dollar signs in the formulaand then moving the cell or cells to a different location

these are the only ways i know to do linking formulas


If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the Reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Many Thanks

Mark East
MOUS Master Instructor

Hi Ben, just to add a little bit to Mark's answer; perhaps a variation on the theme:
You will need two workbooks to create a link. Call the first one Source. The second workbook we can call Dependent. It is now time to create a link between the workbooks; Have both workbooks open.
In the Source Workbook: select a cell; this is the cell you want to refer to. You want to insert this value into your Dependant workbook.
Click the Copy button or choose Copy from the Edit menu. A moving border (marching ants) should appear around the cell.
Switch to the Dependant workbook. This is the workbook where you want to paste the linked data.
Select a cell; This is the cell in which you want the linked data to appear. Choose Paste Special from the Edit menu. The Paste Special dialog box should appear:
Choose All in the Paste box and None in the Operation box.
Choose the Paste Link button to paste the link into the cell.
Observe the cell; Excel has created an external reference formula that links the workbooks. This formula appears in the formula bar. You have successfully linked two documents. Best regards Pete