Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.

Specializing in Advanced Spreadsheet & Office Macro Solutions.

Tested on Microsoft® Outlook® Versions: 2000 (9.0), XP (10.0) - should work on any version from Office 97

You open Outlook and get an worrying error message: your email / calendar / contacts file is corrupted and can't be opened. You've just lost everything on it!!!

Well, not exactly. It is possible to recover the file, partially or even totally, usually with a small loss of the message that provoked the corruption. All with a free utility Microsoft (r) already included on Windows but forgot to tell.

If the damage is recoverable, even if with losses, this tool may
do it for you. And it's free, is already on your Microsoft® Windows
copy.

Microsoft® Hidden Secret

Almost nobody knows, but Microsoft® Windows includes a
non-documented, free-tool to recover Microsoft® Outlook email (and
calendar / tasks / contacts) storage files: the Inbox Repair Tool. To use it to recover a
damaged email file, you have to follow these steps it on your
system:

Find the free Inbox Repair Tool on your system;

Locate the damaged Microsoft® Outlook file on your disk;

Use the Inbox Repair Tool to recover it;

NOTE: the screen-capture pictures on this tip were taken
from Microsoft® Windows 2000. Microsoft® Windows XP is slightly different, but you should be able to do it without trouble.

STEP 1: Find the free Inbox Repair Tool on your system

1) Use the file search tool on Microsoft® Windows Start Menu:

2) Search for a file called scanpst.exe:

3) Launch the recovery tool by clicking on its name on the
search results list:

STEP 2: Locate the damaged Microsoft® Outlook file on your disk;

Microsoft® Outlook storage files have a file extension of .PST. But
it doesn't show the
file location, only it's contents. To find where the file is stored,
do this:

1) Place the mouse over the Personal Folder heading on the
Folder List. Use the right mouse button to get the context
menu. Select Properties.

2) On the Properties dialog, press the Advanced button:

3) The name and location of the Outlook Archive file
can be found on the Path field:

4) The archive file will be be found on the indicated
location:

Note that the file appear on Windows as NOT being related to
any application (no application Icon) and you can't open it by
double clicking with the mouse.

WARNING: If the file is really damaged, Outlook may not
allow you to do the steps above. In this case, just use the
Windows File Search tool shown on STEP 1 to locate all email
storage files and recover one by one: Search for files called *.pst

STEP 3: Use the Inbox Repair Tool to recover
it

1) Use the Browse button to select the storage file
you've just located:

2) Press Start and wait for the recovery process to end:

3) The recovery process results will be shown, at the
end, in a pop-up window:

It says I have losses. What do I do?

Not much. Accept them if you want to recover the remainder of
the file. Usually, when recovering a damaged file, the contents
of the damaged area will be lost, be it email messages, contacts, task
or calendar items.

The best (and probably only) way to protect
against this is to regularly backup your Outlook storage files.
If you want to know more about it, check this tutorial on How
to Backup Outlook files.

The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.

Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.

Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.

Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.

Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.

Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!

Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.

Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.