After I have worked in a spreadsheet, then changed some alterations. I found that on re-opening the spreadsheet, that all the different types of control boxes, have been disabled. Can anyone tell me what is likely to have happened ?
I did not do any changes to the sheet on which the controls are.
When I try to change the selection in the list box, it changes, however the INDEX formula doesn't respond, i.e. if I set up an INDEX formula to reference the control ( that is changing ), it doesn't respond for no apparent reason.
=INDEX(Comps1!L8:O27,Z43,4), is the correct formula, but is not responding, even though Z43 ( THE CONTROL ), is changing.
I have noticed that when I now load this spreadsheet, that during loading the cell reference boxes 1 & A1, appear in the top left corner, until the spreadsheet loads, this never happened before.