Unexpected behavior with scroll bar control

[Simon Karpen]

We have a number of spreadsheets that use the scroll bar control to
change numbers used by formulas, graphs, etc.

On Excel 2001 (v.x) and XP, they work as expected; when you slide the
scrollbar, the scrollbar slides in real-time (and the numbers, graph,
etc change in realtime)

On Excel 2004 (SP2, all updates), when you slide the scrollbar, the data
is updated but the scrollbar doesn't move until you release the mouse
button.

(this is a standard scrollbar from the format toolbar, nothing special.
I can reproduce with nothing but a scrollbar in a worksheet).

Is this expected behavior? A bug? Does anybody have a workaround?

Thanks,
--Simon

 

[CyberTaz]

Hello Simon -

I'm running XL 2004 as you describe, but the scroll bar works as you
prefer... Dragging it causes it to move as the sheet scrolls, and, AFAIK,
this is how it should be.

There is a setting in XL Preferences to turn each scroll bar _off_
altogether, but no setting I know of to modify the behavior if it is
displayed.

What happens if you use the scroll bar arrow buttons at the bottom of the
scroll bar? Anything more you can share about the situation? How do the
scroll bars behave in other applications?

BTW - What did you mean by;

What does the Formatting Toolbar have to do with it?

Regards |:>)

 

[Simon Karpen]

Hello Simon -

I'm running XL 2004 as you describe, but the scroll bar works as you
prefer... Dragging it causes it to move as the sheet scrolls, and, AFAIK,
this is how it should be.

See below. I'm not talking about the standard application scroll bars,
I'm talking about the scroll bar control from the format toolbar. It's
very much not the same thing; it's a slider *within* a spreadsheet.

What does the Formatting Toolbar have to do with it?

The formatting toolbar is where you get your standard scroll bar
control. I'm talking about a scroll bar within a spreadsheet, not on the
edge of one.

 

[JE McGimpsey]

I'm talking about a scroll bar within a spreadsheet, not on the edge
of one.

The lack of real-time updating appears to me to be a bug. MacBU should
see this message, and I've sent a separate notification to them.