Welcome to MSDN Blogs Sign in | Join | Help

Microsoft Excel

The team blog for Microsoft Excel and Excel Services.
A Small Piece Of Pleasant News For Those Of Us That Write Code In Office, Plus Some More Screenshots …

Any readers that have written VB using the VBA editor in Microsoft Office has probably noticed that historically, their mouse scroll wheel (or equivalent) does not work in the code window.  I just noticed in recent builds of Office 2007 that it does.  I am not sure when, exactly, that was fixed, but I am happy to report that it has been, so there you go.

Additionally, I sort of blew it in the last post when I didn’t include any screenshots of a PivotTable with Page Fields (or “Report Filters” as we are calling them in Excel 2007).  Since they look sharp, I wanted to redress that.  Here are 4 of the PivotTables I showed you last time with Report Filters added.  Note that they have lost that “button” look and are now nicely formatted text.


(Click to enlarge)

While I was at it, I thought I would include a shot of multi-select in PivotTable Report Filters.  In this case, the PivotTable is bound to an OLAP cube, so there is dimensionality to what can be filtered.


Posted: Tuesday, April 04, 2006 2:41 PM by David Gainer

Comments

Jordan Windebank said:

David, thank you. The scroll wheel issues has to be one of the biggest problems in my day to day work, even the third-party workarounds I have found don't cut it.

This is fantastic news. :)

Regards,
Jordan
# April 4, 2006 7:19 PM

Sana said:

That's odd.  I use a Logitech MX mouse and the scroll wheel works in the code window with Office 2003.

Will Office users/developers be able to add and remove items from the Ribbon?  Also, are there any changes to the toolbar icon editor included in Office, which is currently very option limited?
# April 4, 2006 8:48 PM

dodo said:

In my opinion the line underlying Canada separates Canada from its provinces and visually connects it to Australia's ones. This is very confusing.
# April 4, 2006 10:15 PM

Jon Peltier said:

Very nice formatting, although I agree with dodo's assessment of the misplaced heavy line.

I've used Gasanov's VBScroll utility and never had any difficulty with the scroll wheel in the VBE.
# April 4, 2006 11:22 PM

Thomas said:

I also use VBScroll by Shahin Gasanov, an excellent piece of utility for the VBE...
# April 5, 2006 3:58 AM

Phylyp said:

The new features in pivot tables are fantastic. I especially like the treeview style, since it presents hierarchical information in a compact manner.

Business users will love this.

<nitpick>The downward pointing arrow for the report filters button should probably come to the right of the funnel... esp. for LTR reading</nitpick>
# April 5, 2006 5:26 AM

John Greenan said:

Scroll wheel - working?  Hurray!

Just don't break it!
# April 5, 2006 6:06 AM

Mike Woodhouse said:

I think the VBScroll utility is needed for MS Mouse drivers, which don't work very well with MS software (grin). So at work (MS optical mouse) I need VBScroll, at home (Logitech) it's never been necessary. But it's all good - another small addition to the (long) list of reasons to be looking forward to Office 2007.
# April 5, 2006 9:43 AM

Tianwei said:

Dave,

The report filters look great. Thanks! Oh, and the scroller in VB Editor, fantastic!

On my previous post point #3. I figure your answer will benefit a lot of users so I will elaborate here: many times I create a big pivottable with a lot of data fields, calculated and formatted after tedious steps of going into every data field and renaming, selecting options, formatting, etc. In Excel 2000, these data fields will line up under a new "row/column" button called "data", click that button it looks like a normal column/row fields with check boxes to each data element. However, the "data" button does not behave the same way: if you uncheck a data element, it's gone forever, as if you go in pivottable wizard and drag the data field out. To get it back you'd have to find the field then drag back in, renaming, reformatting, etc all over again.  This is a huge headache personally since often I want to look at one element at a time for better viewing/analyzing but I dont want to jump the hoops everytime to recreat the data field. After setting up pivottable once with all possible data elements I want to analyze, I'd like for them to be at the finger tips however combination intended at that time without having to go through wizard. Hopefully I explained the situation.
# April 5, 2006 9:58 AM

David Gainer said:

Sana, developers will be able to extend the ribbon.  Here is a category of posts on this topic from the UI team's blog: https://blogs.msdn.com/jensenh/archive/category/11280.aspx

Dodo, thanks for the feedback.

Tianwei, we have actually removed the data field filter dialog you mention in 2007.  We found that almost no one even knew it was there, and those that did were not happy with its behaviour.  I hope we have solved most of your problems, though.  Caption changes should persist adding and removing a field, and styles should make it so you don't need to re-format every time you add a field.
# April 5, 2006 6:41 PM

-marc said:

Intersting
I use Logitech MX 500 Optical Mouse.
Does not scroll in vside or vbe.

Thanks for the vbscroll reference
Hoep it works with the ref'd mouse

Thanks
-marc
# April 9, 2006 4:47 PM
New Comments to this post are disabled
Page view tracker