Trouble Shooting

In no particular order ...

N1Engine.xla could not be found (also applies to N1DB.xla) 

First, try running the Load Add-ins utility. If that doesn't work, then manually load the add-ins.

Excel 2000 to 2003:
  1. Tools > Options > Add-Ins 
  2. Scroll down the list and make sure Narrative1 Appraisal Engine is selected. If it is already checked: Click Browse and navigate* to C:\Program Files\Narrative1 and select N1Engine.xla. You will be asked to place the an existing file, click Yes.
Excel 2007:
  1. Click the Office button (top left) then select Excel Options (bottom right).
  2. Select Add-Ins on the left side then select Manage: Excel Add-ins and Click Go ...
  3. Scroll down the list and make sure Narrative1 Appraisal Engine is selected. If it is already checked: Click Browse and navigate* to C:\Program Files\Narrative1 and select N1Engine.xla. You will be asked to place the an existing file, click Yes.
* The path may be different on your computer.


No Menus in Word 

(or Run time error ‘-2147352573 (80020003)’: unable to run the specified macro)

Word 2000 to 2003:
  1. Tools > Options > Templates and Add-Ins 
  2. Make sure N1Code.dot is selected. If it is already checked: Click Add... and navigate* to C:\ ..Windows\Word\Startup and select N1Code.dot
Word 2007 and Later:
  1. Click the Office button (top left) then select Word Options (bottom right).
  2. Select Add-Ins on the left side then select Manage: Word Add-ins and Click Go ...
  3. Make sure N1Code.dot and N1Ribbom.dotm are selected. If it is already checked: Click Add... and navigate* to C:\ ..Windows\Word\Startup and select N1Code.dot and N1Ribbon.dotm
* The Word Startup folder is tricky to find. Some examples from our computers:

    Windows XP:
        c:\documents and settings\owner\application data\microsoft\word\startup

    Windows 7:
        c:\users\tom\appdata\roaming\microsoft\word\startup

Tables are not merging/updating saving save tables merging tables not working tables not updating

This appears to be a phenomenon related to Microsoft's Clipboard. 

First try "Get Tables" from the Narrative1 Options menu.  This feature was introduced on 5/3/10; prior versions have "My Charts", which is not identical in what it does, but worth trying.

Secondly, clear your clipboard.  To do this in Windows Vista and Windows 7, follow these instructions:
  1. From your Start menu, select either Programs or All Programs, depending on your Windows version.  Select or click on the Accessories folder, and click on the Command Prompt shortcut.  A small window appears with a place to type in text.
  2. Type echo off | clip and press the Enter key.  If successful, no words will appear except another place to enter text.
  3. Close the Command Prompt box. 
  4. Go directly to your Excel file and Save Fields and TablesUpdate your fields and tables in the Word document.

Finally, try running the Load Add-ins utility. If this does not work, try re-booting, the run the Load-Add-ins utility. 


Database Calculate All error

An error can result if a calculation has been been saved for a field that was subsequently deleted from the database. Remove any calculations that reference a database filed that has been deleted from the database. 





This Does Not Appear to Be a Narrative1 Comps Management File

Occasionally, a user may encounter an error that says "This does not appear to be a Narrative1 Comps Management file".  A cause for this error may be that the file was saved in a .xlsx format.  If an N1Appraisal Excel workbook is saved in a .xlsx format, the macro functionality disappears.  For more information, refer to the FAQs