Quickly Copy Outlook Appointment's Tracking Status to Any Other Program

Scheduled an appointment in Outlook and want to quickly get the attendees' tracking status to say - Meeting Minutes or notes?

In Outlook 2010 this is easy:

• Open the appointment in Outlook
• In the Meeting ribbon click the small arrow under Tracking button
• Click "Copy Status to Clipboard"
• Open Word/Excel/other and paste - you're done!

How to copy Outlook appointment tracking status

The format is pure text with tab separated values so you can paste it to almost any program.

Limit the number of times a file can be opened

Excellent tip on Excel Blog: VBA tip: Limit the number of times a file can be opened

Article author Bob Umlas (Excel MVP) shows a convenient usage of SaveSetting and GetSetting methods, take a look!

Using Access Data in Excel

Did you know there are three ways how to use Access data in Excel?

Whether you have an existing database, or you set up a fresh database for your data see Access blog's posting for the tips. You will learn all the different methods how to bring Access data into Excel for analysis.

Ways to use Access data in Excel >>

Excel VBA: How to Break Links to External Workbooks

Back in 2007 one of the prettiest pieces of VBA code was given free to the people. If you have ever needed a good programmatic way to remove all external workbook links from a single workbook, check this link.

Top Microsoft Twitter Accounts Every Cubicle Worker Shoud Follow

@MSExcel - Official Twitter account of the product team that brings to you a little piece of software we call Excel.

@msaccess - I am Ryan McMinn a Program Manager on the Access Team; email me at ryan.mcminn@microsoft.com

@Office - Tweets to help you do more with Office at work, home and school. 

@OfficeBI - Covering Microsoft's Business Intelligence products on the Office Platform including SharePoint, Excel, & Excel Services.

@Office_Live - Tweets from the team at Microsoft Office Live

@SharePoint - The SharePoint Product Group

@ch9 -  Channel 9 keeps you up to date with videos from people behind the scenes building products at Microsoft.

Excel VBA: Remove All Conditional Formatting From Sheet

At times you may experience issues with macros when having lots of conditional formatting rules on a sheet. Here's the magic with which you can remove all conditional formatting rules from a sheet:

Sheets("MySheet").Cells.FormatConditions.Delete

Show Details On-demand in Excel

Excellent sample of how to create an on-demand details chart - by Chandoo.org.