Calculation mode changes thumb

Why does Excel’s calculation mode keep changing?

You’re probably aware that Excel has two main calculation modes: automatic and manual. Automatic calculation will re-calculate the workbook when a value changes or based on specific actions (inserting, deleting, hiding rows/columns, or renaming a worksheet). Manual calculation only re-calculates when specifically requested by the user. Click Formulas -> Calculation -> Calculate Now (shortcut key Read More

Automatically open workbooks thumb

Automatically open workbooks when Excel starts

There are a lot of circumstances where it is useful for a specific workbook, or workbooks to open whenever Excel starts: Save time by opening workbooks you always use To control the calculation mode To trigger VBA events when you open Excel This isn’t just something interesting you can do with Excel, it’s actually a Read More

Change number format based on value

Change number format based on a cells value

Imagine a situation where you have built a dynamic report or dashboard that you a really proud of.  The user can make selections from a drop-down box and the report updates automatically, it’s a beautiful thing.  There is just one issue with these types of dynamic reports/dashboards – not all the information is of the Read More

Edit links in Powerpoint using Excel VBA Thumb

Linking Excel files to PowerPoint

If you regularly create PowerPoint presentations that include information from Excel, you will know how frustrating it can be.  Having to re-copy and re-paste the information every time a change is made in the original Excel documents.  Have you come across the feature which enables you to link your Excel workbook directly into your PowerPoint Read More

Make workbook read only for everybody Thumb

Make a workbook read-only for everybody but me

I was recently asked this question – “How can I make my workbook read-only?”.  I gave the person an answer.  However, the real question they were asking turned out to be “How can I make my workbook read-only for everybody but me”.  In this post, we will explore some of the options available.   Save Read More