Does now.... can't explain it. When I downloaded it the first time it showed functions that dont work on a Mac (scroll bars, drop boxes etc), and the sheet was simply dead in the water. Saved it my desktop and still nothing. This time clicked on the Data validation cell and up pops a Group box which wont go away. Data validation works and single chart changes as it should. Going to close down the system, go to bed and hopefully all is well in the morning.

Thank you Georgiboy for your assistance.