General Tips
Disable the Excel Compatibility Checker
Submitted by Ken Puls on Wed, 2008-09-24 19:26. Excel - VBA | General TipsI've received several comments on my blog that people dislike Excel 2007's Compatibility Checker, and would like to turn it off globally. While it's true that you can turn it off for each workbook, the main user interface seems devoid of a way to actually tell Excel that you never want to check your workbooks for compatibility when saving to 2003 or earlier versions.
This issue seems to hit me most when trying to an Excel 2007 workbook that uses conditional formats or colours (colors) back into the Excel 2003 file format.
Outlook 2007 Time Saving Tips - Creating Email Groups
Submitted by Ken Puls on Sun, 2008-03-02 20:35. General Tips | Outlook - General TipsIntroduction:
Due to a recent migration from a Novell to Microsoft, our company has also migrated from Novell Groupwise to Outlook 2007. This article is one of a series of short "How To" articles that I have been publishing internally to make the transition easier. Please keep in mind that this was written with Outlook 2007 in mind, so you may have to follow slightly different steps to make this work in earlier Outlook version.
Creating Groups
Creating your own Groups of email addresses is a handy function, as it allows you to send email to a pre-defined collection of people easily, without having to remember their names or email addresses. Whether you are on a server at work, trying to define a group of people to receive regular reports, or you want to set up a group at home to forward all your jokes to, this can save you a ton of time in the long run.
Outlook 2007 Time Saving Tips - Creating a Signature File
Submitted by Ken Puls on Sun, 2008-03-02 19:31. General Tips | Outlook - General TipsIntroduction:
Due to a recent migration from a Novell to Microsoft, our company has also migrated from Novell Groupwise to Outlook 2007. This article is one of a series of short "How To" articles that I have been publishing internally to make the transition easier. Please keep in mind that this was written with Outlook 2007 in mind, so you may have to follow slightly different steps to make this work in earlier Outlook version.
Creating a signature file
In most email programs, you can set up a signature to be automatically added to all of your emails, and Outlook 2007 is no different. This saves you the hassle of typing your name and contact information every time you send an email, so is quite a useful feature.
A message to forum cross posters
Submitted by Ken Puls on Sat, 2006-06-03 20:12. General TipsDo you know why you're here?
If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts.
Online forums are great, plain and simple. They are full of people who both ask and answer questions, and it's answers that all new posters seem to be after. I certainly know that it was the motivating reason for me to join my first one. Even better, these forums are free. And therein lies our issue...
Every individual who responds to your posts is a volunteer, and is trying to help you in their own free time. That is something that needs to be both recognized and respected. "Sure", you say, "I respect that", but you've been pointed here because you've cross posted somewhere, not told us, and been busted. Rest assured that you are not alone, and that there was enough instances that I built a page so that my friends and I do not need to keep re-typing why this is an issue. This is not intended as a lecture, and if you make it to the bottom, you'll even see that I am truly trying to help you.


