Forum Discussion
Make External Cell References Relative by Default
Just need to know if this is possible, I have a user asking if the default can be changed and I haven't found a definitive answer yet. When you're in the formula bar and reference a cell located ...
My suggestion is Click Another Workbook Reference -> Rename -> Apply 'F4'
It will remove '$' symbol. $A$10 will become A10.
Hello Stephan
There are only a few situations when Excel uses absolute references as a default.
Besides external workbook references it also happens with cell references when defining a name.
I guess that MS wanted to 'protect' the users from problems caused by relative references in these cases.
And I think there is no setting to change this default behaviour.
