Xl2007

[xenou]

I have joined the XL2007 club (at work - they forced it on me ). Generally pleasantly surprised - no flubs with my macros, ribbon isn't as bad as I though it would be (I loaded up the QAT and minimized the ribbon to keep more space for cells - between my QAT, keyboard shorts, and right-click menus I hardly even need to use the ribbon really). The file size is quite significant with the new compressed formats -- a file that was 5MB in 2003 reduced to 889kb as an XL2007 binary file format, and I believe the OfficeOpenXML format was only a little larger.

One annoyance - does anyone know a fix? As I mentioned, I've decided to go with the ribbon minimized. But whenever a context tab appears and I click it (such as the Pivot Table tab, Chart tab, Table Design tab) the ribbon maximizes and (alas) stays maximized - it doesn't seem that these tabs are "aware" of the preference to minimize the ribbon.

Regards,
ξ

 

[SydneyGeek]

I haven't seen that behaviour before. Generally, once you click back on the worksheet the ribbon collapses again. Just tried with a Table to check; it works for me.

When does it do this to you?

Denis

 

[xenou]

Thanks Denis. I've checked the behavior again and found the problem. If I click the Design tab itself it's okay. But there's a label above it that causes the result I mentioned in my first post. In the image below, its the element that says "Table Tools" - I'm not even sure what this is called (a super-tab?). But if instead I click the element that says "Design" then all is well.

ribbon image - table design tab

ξ

 

[SydneyGeek]

Not sure what it's called either. Note to self -- avoid!

Denis