I have a front sheet in Excel that is formatted in a colour (say yellow). Sometimes when I do certain actions (such as choose an item from a drop down list in the sheet) contents of other sheets start to appear. They disappear when I scroll away and back (or choose a different sheet and come back).
How do I stop this as my users are starting to complain and get confused that they have broken the model??
How do I stop this as my users are starting to complain and get confused that they have broken the model??
