Associate
- Joined
- 23 Apr 2007
- Posts
- 1,785
- Location
- Cardiff-ish, Wales
Hi guys,
currently using Excel 2007 and something very odd is happening. I'm putting in a formula in cell A1 to pull back a value from another cell, W1. So I've typed in =W1 and it works. Nothing exciting. However, if I try to lock the cell using the F4 cycle then the cell now shows =$W$1 rather than the value.
Any idea what's going on? It's starting to annoy me now
currently using Excel 2007 and something very odd is happening. I'm putting in a formula in cell A1 to pull back a value from another cell, W1. So I've typed in =W1 and it works. Nothing exciting. However, if I try to lock the cell using the F4 cycle then the cell now shows =$W$1 rather than the value.
Any idea what's going on? It's starting to annoy me now