This post may contain affiliate links. Please read my disclosure for more info.

Calc Buddy Add-in

CalcBuddy Add-in

CalcBuddy Add-in

Recently, I wrote a post about what causes Excel’s calculation mode to change.  Many users experience the issue where it changes without them realizing it.  Due to the way Excel handles the calculation mode, the problem can easily be transferred to other workbooks, which can result in users issuing error-filled reports and quoting incorrect numbers.  That’s pretty bad, right!

To help alleviate some of this pain, I’ve created the Calc Buddy Add-in.  Hopefully you won’t be caught out by manual calculation mode again.


Introducing the Calc Buddy Add-in

Calc Buddy allows you to select your preferred calculation mode, then checks the calculation mode each time a workbook is created, opened or saved.  If it is different to your preference, a warning message is displayed.

Warning when opening or creating workbooks:

Calc Buddy - Warning 1

Warning when saving a workbook:

Calc Buddy - Warning 2

It will work for all 3 calculation modes, so if you always work in manual mode or automatic except tables mode, you can select to be notified for that setting instead.

Not sure if Calc Buddy is for you?  Here is what one reader said:

Your calc buddy is a great tool! Thank you so much. We definitely need this add in across our whole team as this issue has impacted numerous people.

R. Swann


Setting up the Calc Buddy Add-in

Calc Buddy does not take up a lot of space in the ribbon.  It will only add a small button to the empty slot in Calculation section of the Formulas tab.

Calc Buddy Added to Formula Ribbon

Click the Calc Buddy icon and a new window will open

Calc Buddy Settings

Use the tick box to enable or disable the warnings.  If enabled, select your preferred calculation mode from the drop-down box, then click Save + Close.

That’s it.  Simple.


Download the Calc Buddy Add-in

Now you know how it works, it’s time to download the Add-in.

The Calc Buddy Add-in is available for newsletter subscribers to download for free.

Existing newsletter subscribers can enter their name and e-mail address into the form below to download instantly.  Or, if you are not a subscriber, you can enter your name and e-mail address below to become one.


Install the Calc Buddy Add-in

The Add-in is easy to install, just follow the instructions below.

  • Unzip the downloaded file
  • Copy the Calc_Buddy.xlam file to a location which is easy to find and you always have access to.
  • As the file was downloaded from the internet, Windows may add a security block to the file, so you will need to change that setting first.
    • Right-click on the file, select Properties.
    • From the Properties menu, ensure the Unblock box in the general tab is ticked (if there is not an Unblock box, ignore this step), then Click OK.
      Calc Buddy Unblock
  • Double-click the file.  The file includes an auto-installer.  Depending on your security settings you may see the following window: Click Enable Macros.
    Calc Buddy Enable Macros
  • You have the option to install the Calc Buddy Add-in or use once.
    Calc Buddy Install Add-in
  • If the Calc Buddy Add-in has installed correctly you should see the following message:
    Calc Buddy Successfully Installed


The Future of Calc Buddy

Obviously, it would be better if this type functionality were built into Excel already, or even better if the calculation mode was applied at the workbook level.  In the future, I hope this feature is added, and Calc Buddy will no longer be required.  Until then, I hope you find it useful.


Still Got Questions?

Which versions of Excel does Calc Buddy work on?
Calc Buddy should work on Excel 2007 – 2016 for Windows and Excel 2011 – 2016 for Mac.

How many devices can I install Calc Buddy onto?
Each license is on a per-user basis for an unlimited number of devices.  You can use Calc Buddy at home, at work and anywhere else you like.

Can I share Calc Buddy with my friends and work colleagues?
Just send them a link to this page and they can sign-up to get their own copy of the Calc Buddy add-in.  If you want a site license for your entire team/business, please contact me to discuss.

Where can I get help if I need it?
The help pages can be accessed from within the Calc Buddy Add-in itself, but can also be found here.

What are the terms of the License?
Find the End User License Agreement here.


Leave a Reply

Your email address will not be published. Required fields are marked *