If you have had the experience of Excel shutting down when opening a file you must know how frustrating it is. We experience it regularly, probably due to the size of the spreadsheets we build. However, it is sometimes even a small spreadsheet that perhaps contains a data table.
But when it comes to dates and times, you may have created some sort of tracking spreadsheet that needs to warn you once a certain date/ time is approaching. Is there a trick to auto refresh Excel every minute (with no VBA)?
A problem with the existing settings in Excel is that you cannot change more than 6 default chart colours. You can set up your own customised colours to use for each series but only up to series 6. This shows some workarounds.
Our 2018 Rugby Six Nations Predictions Spreadsheet enables up to 50 participants to predict the round robin and final winners (overall, grand slam, triple crown and wooden spoon) and compete to see who can be closest in predicting the overall result and the scores of each team.