Search results

Yep, it's that guy. I can solve it by setting calculations mode to "Automatic except Data Tables", but that is, of course, not optimal. It seems as if when the calculations are slow to update the scrollbar keeps moving. Frustrating. Solutions still welcome. This is not a huge sheet we are...

Hui, you have given me an idea. I have been deleting things to find the source of the problem and I think I have it. The spreadsheet includes three Data Tables (I think that is what it is called; I am using Excel in Spanish), generated off the two variable being changed by the scrollbars...

Well spotted. I have deleted all of them since they don't seem to be used anywhere. However it has not resolved the issue. :( Thanks Jonathan

Hi Hui, Thanks for jumping in here. 1. There is no VBA code in this spreadsheet as we are not allowed to use it - our files are available for people whose companies are very security conscious. 2. They are not linked to each other. Each is linked to a single cell which is then used in a...

I am using Excel 2007 and I have a spreadsheet with two scrollbars (not ActiveX). Both of them exhibit the strange behaviour that, if one clicks the arrows at the end or in the bar outside the scroll block, the scrollbar will run all the way to one end, not moving by just the correct increment...