Knowledge Pack: Track Changes in Word

Track Changes in Word is useful but also confusing – and can even be very dangerous. Read these articles to understand how to use it effectively and safely.

Too many Track Changes? Confused? Here is the solution!
Office Politics: How to enable Track Changes without the other party knowing it!
Office Politics Secrets: Practical use of Track Changes
Legal: You can be cheated using Track Changes
Comparing Compare and Combine!
Document Protection: Quick Reference

Knowledge Pack: Green Marks in Excel

These marks indicate some potential error. Outdated formulas, numbers stored as text and so on. If you ignore these errors, you are at a significant risk of viewing and using wrong data for your decision making. Here is a set of articles which explain exactly how to utilize these green marks to your advantage. These are your best friend.

Never interpret anything in any Excel file unless you are sure that all the green marks are handled (all potential errors are corrected!).

  1. Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!!
  2. Green Marks Part 2: Formulas showing wrong results!
  3. Green Marks Part 3: More error handling
  4. Green Marks Part 4: Inconsistent Formulas
  5. Green Marks Part 5/5 (Background Error Checking in Excel)

Share this critical information with your boss, colleagues, subordinates and loved ones. Everyone needs to know this!

Knowledge Pack: Word Tables

A collection of articles covering nuances and usage scenarios of Word Tables.

The curious case of Column Widths in Word tables
Using Formulas in Word tables
Efficiency Test 2: Word
Efficiency Test 4: Word and Efficiency Test 4 : Word : Solution
Create complex tables in seconds
Frustration = Feature Guarantee! (Table Row breaking across pages)
Reorder Word table rows instantly
How to convert multiple column data to a simple list
Building Blocks in Word – The ultimate reuse engine
How to sort a comma separated list in alphabetical order
Table going outside the page? Three click solution.

Blocking others from editing parts of the document

Word documents stored on OneDrive and SharePoint can be edited by more than one persons simultaneously. This is a very useful and powerful feature. (Read this article for details). Each person can edit in different places. Temporarily the current paragraph is locked for others. When the document is saved, the paragraph is automatically unlocked so that others can work on it.

Continue reading Blocking others from editing parts of the document

Something going wrong? Try SAFE mode

This works for all Office products. When things go wrong or the application starts very slowly, or gets hung while starting or misbehaves in any way, it is worth trying starting it in SAFE mode.  How do you do that? Simple.

Press CTRL key while clicking on the Office Application Icon. It will ask you if you want Safe mode. Choose Yes.

Safe Mode in Office

Another method is to use a command-line switch – more useful to techies. Press Windows Key and R. The run dialog opens. Write the application name followed by /safe and press Enter. For example:

winword /safe

Here are the exact application names for all products:
winword, excel, powerpnt, outlook, mspub, msaccess, onenote

Benefits?

It opens the application with no customization. All your custom settings are replaced with default settings. No add-ins are loaded. This usually makes the application start very quickly. And now you can troubleshoot which item or setting is causing the problem.

Starting in safe mode is NOT a permanent solution. It is usually the first step in troubleshooting causes of application instability or crashes.

***

What did I learn today: Clear Outlook Categories (For Demo Warriors)

This article is relevant for people who conduct demos or training on Outlook. During demos we create custom color Outlook Categories. These categories remain customized for the next demo as well.

Ideally I would want the categories to have default names (Red Category, Blue Category and so on). How to clean all of them quickly just before the demo? Simple.

Start Outlook with the Startup Switch /cleancategories

<office installation path>outlook.exe /cleancategories.

This DOES NOT remove custom categories which have already been applied to Outlook items like mails, appointments or tasks. These have to be removed separately. But it does remove the custom descriptions. Now the category dialog looks like this.

Clear Outlook categories

Here are many more Outlook related articles.