Open file error when start Excel

Recently, it must be after some sort of update pushed from the corporate server, whenever I open an Excel file or just start the blank Excel program, it gives me two errors.

This is the first:







Once I click OK, it gives me the second:





This is so annoying that every time I have to see this and sometimes, I just wait it open then find those pop-ups are waiting for me to click OK again.  So I did some googling and found the solution.

In general, first check would be in the Excel settings, here are the steps I got from ExpertsExchange (Q_26790488):

1) click office button
2) Select Excel Options
3) On the left pane, click Add-Ins
4) You’ll see a list of add-ins, try to identify which addin is the one mentioned in the error message
5) You can also select "Manage Excel Add-Ins" and click Go, to see the standard add-ins (XLA and XLAM)…
6) in any case (4 or 5) make sure you disable the one causing the issue.

Since I don’t have such Magic.xlam file or anything funny in my settings, so I continued my research.  Then the Accepted Solution down in the thread gave me a hint to search for the ~$Magic.xlam, which obviously looks like a corrupted file.  I found it in "C:\Program Files\Microsoft Office\Office15\XLSTART" folder, and then deleted it.

After that, Excel opens without a problem.



How to fix KMS error in Office 2013 Activation

First of all assume that your KMS is functional, having Office 2013 key installed.  Also the client is able to reach the KMS server on port 1688, and the setting in your internal DNS system is correct.

You can check registry on the client for this:

HKLM\Software\Microsoft\OfficeSoftwareProtectionPlatform\KeyManagementServiceName (REG_SZ)

Here are the two commands you can try specify the KMS server and do manual activation.

cscript ospp.vbs /sethst:fqdn_of_your_kms_server

cscript ospp.vbs /act

For Windows activation, the commands are like this:

  1. cscript slmgr.vbs /skms fqdn_of_your_kms_server
  2. cscript slmgr.vbs /ato

Further, you may want to try uninstalling the product key on a client and then reinstalling it.

slmgr /upk xxxxx-xxxxx-xxxxx-xxxxx-xxxxx
then slmgr /ipk xxxxx-xxxxx-xxxxx-xxxxx-xxxxx

Reference page from Microsoft:

Active an Office KMS host offline

To active an Office KMS host via the Internet, you can follow the instructions in the following links:

But if you want to keep your KMS host off from the Internet, you can use the Deployment Guide for Office 2013, which can be downloaded from Microsoft.  Here are some notes:

  1. Run the following command under C:\Windows\system32. The result is the installation ID for Office 2013.  You will type this installation ID number into the telephone in step 3.
    cscript slmgr.vbs /dti 2E28138A-847F-42BC-9752-61B03FFF33CD
    Note: The 2E28138A-847F-42BC-9752-61B03FFF33CD value is the Office 2013 activation ID (which is public).  Paste this value exactly as shown.  We recommend pasting this number into Notepad, and then breaking up the number into six groups of six numbers.
  2. Run slui.exe 4, and then call the telephone number displayed, based on which country you are in.
    Note: Ignore the displayed installation ID. This is for Windows.
  3. At each prompt, enter a group of six numbers. This is the installation ID for Office 2013 that you obtained in step 1.
  4. When you hear the response, note the numbers – write them down on the paper, not in the box on the screen.
  5. Run cscript slmgr.vbs /atp xxxxxxxxxxxx 2E28138A-847F-42BC-9752-61B03FFF33CD, where xxxxxxxxxxxx is the confirmation ID that you receive by telephone (there should be 48 numbers).
    Note: The 2E28138A-847F-42BC-9752-61B03FFF33CD value is the Office 2013 activation ID, which is exactly the same as in step 1. Therefore, paste this value exactly as shown.
  6. You should see a message that the confirmation ID was successfully deposited.