Category Archives: Tips & Tricks

Day to Day tips for users

Excel formulas not working properly

Excel, Microsoft, Tips & Tricks

I recently had an issue where a user copied an old Excel Spreadsheet to create a new yearly file.

When the new file was opened and data was entered, they found that the formulas were not updating as expected. I tried re-creating the formulas with no luck. When I googled the problem I found the answer.

I’m not sure why this happened, but Automatic updating of formulas was set to Manual. Here are the steps to re-enable Automatic updating of Formulas. This is based on Excel 2010, but I am sure the setting is available on most version of Excel.

Open the spreadsheet with the problem, the select the Formulas tab at the top.

Then choose Automatic from the Calculation Options button on the far right.

Make sure to save the file as you exit.

I found the solution here:  https://www.ablebits.com/office-addins-blog/2016/02/03/excel-formulas-not-working/#excel-formulas-not-updating

There are other problems solved on this webpage too, so you might take a look.

 

MAPI error when trying to send Word or Excel Document

Tips & Tricks

If you are seeing a MAPI error when using the send to e-mail recipient dialog within Word or Excel, this should fix the issue.

Resolution

To resolve this issue, follow these steps:

  1. Start Windows Explorer.
  2. Close out of Outlook, make sure there are no Outlook.exe processes hanging.
  3. Locate and then open the following folder on your computer:
    C:\Program Files\Common Files\System\Msmapi\1033  Note:  if there is not a Msmapi folder here, then look in:

    C:\Program Files (x86)\Common Files\System\Msmapi\1033

  4. Right-click the MSMapi32.dll file, and then click Rename.Note The file (Msmapi32.dll) that you are renaming differs from the file (Mapi32.dll) that is mentioned in the error message.
  5. Type Msmapi32.old, and then press ENTER to rename the file.

Restart Outlook, it will re-install the MSMapi32.dll file for you and hopefully fix the issue.

Although this is a fix for Outlook 2003, it seems to work for issues related to Outlook 2010 as well. Here is the link where I found the fix: https://support.microsoft.com/en-us/help/926196/error-message-when-you-try-to-start-outlook-2003-mapi32-dll-is-corrupt