Forum Discussion
How to unlink cells in Format Control
I am developing a survey in excel (because the questions are complicated and long and do not format well in e.g. MS Forms) and using option buttons to choose responses. Each question has 6 potential ...
Thank you m_tarler...
Excel does appear to be treating each of the different groups as all part of the same group and updating the linked cell from one group will update them all
OK so I think I reproduced the problem. When I created 1 group box and then added all the select buttons into that box then after they were all created I moved them out of the box (or to a new box) they stayed linked to the original set. If I then removed the group box and added a new group box, it appeared to fix the issue but I did have to assign the referrence cell again.
The easiest way I found to delete or remove is to right click the name of the box then click somewhere else to get rid of the context menu then click Delete.
Hope that helps