Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating links - Unexplained behaviour
I have a workbook with 5 worksheets, N, S, E, W and Summary.
On the N, S, E, W worksheets in cell F15 is a sum calculation, =sum(B15:E15). I want to link each of the 4 sums in F15 to the summary worksheet and then get an overall sum. If I copy F15 to the clipboard from the N worksheet, go to the Summary worksheet, select a cell and paste a link from Paste Special, and then click the next cell down into which I want to link from the S worksheet, everything is fine, I get =N!$F$15. However, if I press Enter, I get an error =SUM(#REF!) and Excel does not move to the next cell below. Could someone please explain why I am not able to use the Enter key in this type of operation. Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a blank when links can't update | Links and Linking in Excel | |||
Creating Relative Links in Excel... | Excel Discussion (Misc queries) | |||
Creating links to a worksheet on a network. | Excel Worksheet Functions | |||
Creating links to a worksheet on a network. | Excel Worksheet Functions | |||
Links creating REF!! | Links and Linking in Excel |