A Microsoft® Certified Trainer, Melissa Esquibel combines her 25+ years experience in information technology with a background in training, technical writing and business risk analysis. Her goal: To take you from "No, how?" to "Know how!"
This can be a sticky wicket if you’ve ever inherited a workbook that has charts linking data from several locations. Until you know how its put together, you either don’t change anything, or change one thing and watch all of it fall apart...
If you have a workbook that everyone views a little bit differently, you can automate it, so that everyone just has to click their own button. Even if you are the only one who uses it, but you use it differently for different purposes, this solution would work, too.
Say Yes to Archive! When the Archive prompt comes up, just say Yes! You probably don’t realize it, but when Outlook archives an email, it just goes to a separate file structure which is still accessible from the Navigation Pane. This process keeps your Inbox and regular folders clean, neat and current, while still allowing you to easily access your older ones.