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