KBA-01739: Cannot Open a Copy While Template is Open

Problem:

When trying to open a Microsoft Excel workbook (such as BFA or SOV), you get a message similar to this:

Cannot open a copy while the template 'sfBFA.xltx' is open.

Solution:

This error is likely caused by a Microsoft Excel Add-In.  To resolve this issue:

  1. Open Excel outside of Spitfire.
  2. Go to the File menu and select Options.
  3. In Excel Options, select Add-ins and look for the Manage drop-down at the bottom.
  4. Select Excel Add-ins then click Go.
  5. If anything is checked, uncheck it to disable it then click OK.
  6. Select the next option in the Manage drop-down (COM Add-ins) and repeat the process.
  7. Repeat for other options in the Manage drop-down.  The idea is to disable ALL Add-ins.
  8. Click OK at the Excel Options window and close Excel.
  9. Back in Spitfire, you should be able to open your workbook now.

Additional Comments:

If you want to keep an Add-in:

  1. Disable it when you disable all Add-ins.
  2. Check that you can open the workbook in Spitfire.
  3. Enable the Add-in again.
  4. Check that you can still open the workbook in Spitfire. If you can, you can keep that particular Add-in enabled. If you can’t open the workbook in Spitfire, you’ll need to keep that particular Add-in disabled.

 


KBA-01739; Last updated: May 2, 2018 at 10:20 am