With Excel to a other file references
To a reference with Excel, you will need to open both files. Then proceed as follows:
- You put an equal sign (=) in the row in which you want to perform calculations.
- Now switch to the other file and select the cell with the number you need for your calculations.
- Then go into your calculation document and quit button the calculation with the input.
- Click again in the row with the result and watch the course of events. At the end you will always find the line of words from the document office dollar sign in front of it.
- Since, however, these must be removed, mark this field and then press three times the button [F4]. Subsequently, the two dollars should be gone sign. See also the Screenshot.
- Then press Enter and the entries, drag the left, bottom of the cell with the small cross as long as until you have transferred all of the essential key figures.
- In the end, you'll find the "Auto fill options" with a small blue table. Click on it and select "Without formatting fill". Your reference between the two Excel files was created.
Excel: reference to other file
Should Excel even display incorrect results, can be found in a further practical tip reasons why Excel sometimes incorrectly attributed.
