Excel Semi-Pro Microblog

I just used my first Excel 2007 Pivot Chart and noticed the Page Field Filters don’t show up on the chart, like they do in Excel 2003. How is someone to know if there is a filter applied to the chart data if they can’t see it on the chart?

Am I doing something wrong? And more importantly, how can I get the page filters to show up on the chart when printed?

Please, only qualified, intelligent responses.

In my article about Microsoft Query I’m getting a couple of comments about Lion not working with Excel for Mac. Everything I’ve seen online says that most people are using Excel 2011 with Lion and have no problems.

Excel 2008 if previously installed seems to work okay as well, however the install program on Office 2008 is purported to use PowerPC which does not work with Lion. 

If you’re going to install Lion like I will probably do this weekend, back up your entire hard drive and update all your software before you do it.

I’ve been busy with some activity related to a career change that will happen soon and haven’t had time to post anything of substance. I’ve just returned from two weeks in Ireland where I installed a couple of Excel reporting systems and came across the dreaded regional date settings.

I’ll be posting some articles as soon as I get over the jet lag that comes with an eight-hour time change.

Cheers

I use the Paste Special functionality in Excel so frequently that for years I have kept a custom button on my toolbar for easy access. Today I stumbled upon the keyboard shortcut for Paste Special and was stunned that I hadn’t known about its existence.

Ctrl+Alt+V is now burned into my memory.

I wrote a VBA subroutine in Excel 2007 to report on the contents of the VBA Project on a worksheet so I could see the number of modules, lines of code, etc. 

Then I tried to run this macro with Excel 2010 and it wouldn’t execute. It finally dawned on me that you have to allow access to the VBA project in Settings.

So I had to choose Developer > Macro Security and check the box to Trust access to the VBA project object model.

And then my code ran like a hot knife through butter.

Don’t think about VBA programming code when you’re taking your contact lenses out at night. You just might find out in the morning the left contact is in the right eye, and the right contact is in the left eye.