weird one this is

I have made a work sheet with 7 sheets in it everything works fine on all sheets apart from the tour pro sheet.It'd fine when it's at 100% zoom but change it to 85% or 115%Zoom and I get #### where the total should be.All other sheet work on any zoom.Anyone got any idea why it does this? Have inclosed the sheet.