Every week I get half a dozen, or so, Excel questions. I invite them via the link a the top of this page labeled “Suggestions”. But I don’t answer the questions, much to the disappointment of the questioner I assume. I just don’t have time. I used to answer questions in the Microsoft’s newsgroups and I was awarded as an MVP because of it. Fortunately for me, the criteria for being an MVP has changed, because I don’t have time to answer questions there either. I did answer two questions on the programming newsgroup today just to see if I still new how.
Why have a link if I’m not going to answer questions? When I created the link, I fully intended to answer those questions. Also, it would stop people from asking unrelated questions in the comments, although that hasn’t stopped entirely. The questions in my Outlook folder where I store such things date back to November of last year. The most recent are two questions from yesterday. All-in-all, there are ninety-three unread messages of 125 total messages in that folder.
I read your page nearly every day. Lot’s of interesting and useful stuff.
I am using Excel 2007 Beta 2 as much as I can to familiarize myself with the new software. I like a lot of the new features including:
- 65k rows (I occasionally draw in data with 100k rows)
- Data filtering with unlimited criteria.
- Sorting with more than 3 criteria
- Right click to change many common parameters. etc
The ribbons are nice, but until you can either import you old menus/buttons or easily add content to the new ribbons, I’m not sure if they’re an improvement for serious Excel users. So far they slow me down a lot. I’m hoping Microsoft will come up with a customize function like the old style drag/drop of previous versions.
My problem is:
I have added customized Excel XP buttons linked to vba code to improve my productivity. If I’m doing some serious work under a deadline, I need to go back to Excel XP. Unfortunately XP and 2007 use the same personal.xls file so once Excel 2007 is opened and closed it asks to update personal file. If you answer “Yes”, it renders the file unreadable in Excel XP. I have tried in vain to find a way to keep a copy of both versions alive. I know Excel 2007 creates a personal.xlsb file if you don’t have a personal.xls file. If I create a macro in Excel 2007 to create the personal.xlsb file and then add my XP personal.xls to the same directory, Excel 2007 will read them both and render the XP version useless.
My answer would involve installing Virtual PC. What’s yours?
I’ve been driving a rental car for the last 10 days due to an auto accident. Today I found out that the other party’s insurance company isn’t going to pay for my repairs or my rental car. Well, they say they’re not going to pay, but I think they will. The other driver was cited for a moving violation and I wasn’t. Now my insurance company has to pay for the repairs and I have to pay for my deductible and the rental car. Then I have to figure out a way to get reimbursed from the other driver or his insurance company. I really don’t need the hassle, but I’ll bet that’s what they’re counting on. That may be a mistake on their part.
Tomorrow I will cooking baby back ribs on my grill. I’ve never cooked ribs on the grill before, so it could be scary. I’m making the sauce and glaze myself, but using a store-bought rub. I’ll enjoy watching Texas beat Ohio State tomorrow night as I’m eating ribs (or pizza if things go south).
So what do you want to talk about this weekend?