I am trying to create a simple relative cell reference to a cell in another workbook which copies the content from that cell to my current worksheet. When I do, it creates an absolute cell reference, which works for that particular cell. But if I copy the formula down to the next cell, it is still pointing absolutely to the original cell in the other worksheet. If I try to remove the $ in the formula to make it a relative cell reference, Excel (2013) simply leaves the formula in the cell without calculating it. What am I doing wrong? I looked in both this forum and online in general and could not find this particular issue. Thank you.