Forum Discussion
annelijne
May 12, 2023Copper Contributor
Why does my formula turn grey when trying to link data from one sheet to the other..???
Hi there... I have been trying to put data from one excel sheet on another I do not want to copy paste cause I want it to stay connected Therefore, using = and selecting the cells I want to co...
Patrick2788
May 12, 2023Silver Contributor
It sounds like the active cell is within a spill but it's not the top-leftmost cell in the spill.
For example:
In the above, to change the formula I must do so in E1.