Forum Discussion
Solved
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.
Hi Stephan,
I never heard such Excel default behaviour (relative references within wookbook and absolute ones on external workbook) can be changed.