In no particular order ...
(This section under construction)
Excel 2003 to Excel 2007 Guide About .xls, .xlsx and .xlsm File Extensions Unprotect/Protect Worksheets About Customizing Hide/Unhide Rows/Columns Quickly changing a large group of fields in Word Copy Sales Grids and Other Worksheets Comps Missing in Word Add Comp Sheets To Word Add additional property description sections (May 2011 Build)
For information on creating fields and tables, see help for Range Names.
Narrative1 Can't Find Google Earth
Finding Latitude and Longitude
How To Clean Out Temp Files
Free Online Flood Maps Load Add-ins Share Comps Percent Values Not Displaying in Grid About .xls, .xlsx and .xlsm File Extensions Prior to Microsoft Office 2007, Microsoft Word and Excel's default file extensions were .doc and .xls, respectively. With the release of Office 2007, Microsoft introduced two versions of these file types, one whose extension ends with x and one whose extension with m. The .xlsx or the .docx files are Office documents that contain XML capability. The .xlsm and the .docm files are Office documents that contain XML capability AND macro capability. Narrative1 uses macros in both Microsoft Word and Microsoft Excel. Therefore, if Narrative1 is running on an Office 2007 or later instance, files that are dependent on Narrative1 functionality must be saved as an Office 2003 or earlier format (.xls or .doc) or as a .xlsm/.docm. If a Narrative1 document is saved in a .xlsx or .docx format, the Narrative1 functionality will no longer be available for use in that document. Top Narrative1 Can't Find Google Earth Right click on the Google Earth icon and select properties, select the target or path that ends with .exe and copy it. When the window comes up indicating an incorrect path, paste the copied path as shown below. Top Unprotect Worksheets
Excel 2000,2003
Sheets will automatically re-protect the next time it is activated, unless all worksheets have been protected via Options.Top Color Codes Narrative1 uses color codes to cue the user for input, or indicate calculated results and auto-fill data. Color codes are also used for navigation markers, help links and tips. Top Copy Grids and Other Worksheets second sales grid new sales grid sales grid 2 second land grid new land grid more buildings in improvements copy sales grid copy land grid To create a second instance of a worksheet, start by right-clicking on the sheet tab. Link the New Worksheet to Word: You will probably need corresponding Narrative for the new Excel worksheet! See Map Fields & Tables. Top Add Extra Comps To Word ("My comps aren't showing up in Word!") By default, the Narrative1 template displays three comps for Land, Sales and Leases. New users often assume that the number of comps used in Excel automatically display in Word. Nope, just three, unless you modify you template. To add more:
Top Property description sections for Land and Improvements may be found in Narrative1 autotext for builds published after May 2011. To update your autotext, click this link.
Simple place the cursor where the property description narrative belongs, find the appropriate autotext and click "Insert at Cursor"
Licensing Policy We license to the user, not to a computer. We want you to use the software wherever you need to work.
Top About Customizing Note that when you branch off and customize a template, new features that are not spreadsheet level work will still be available to you. For example, most database features are not programmed at the spreadsheet level, but rather are "add-in" based. These and other new features will run from your customized template. A word about backups: Save backups often, using a unique name for each backup. An easy method is to right-click on the file name via Windows Explorer and select Copy, then right click again and Paste. Windows will rename the file "Copy x of myfile" each time, and you can do while the file is open. This way if a file becomes corrupt (rare, but it does happen) or if there is an error that you created without realizing it, your backup won't over-write your previous backup and you can roll-back to various points in time. Top How To Clean Out Temp Files Windows & MS Office stores temp files and accumulate over time and can slow your system down. Windows XP:
Hide and Unhide Rows and Columns See PDF attachment below. Quickly changing a large group of fields in Word There are many reasons why you may need to alter the same field that appears over and over in your report. For example, you may want to change acres to square feet, or to square meters. The quickest way to do this is below:
Load Add-ins macro runtime macros add-ins virus add-in Sometimes Excel and/or Word will lose track of the Add-ins and give an errors something like
Programs > Narrative1 > Narrative1 Utilities > Load Add-ins Note: Be sure to close all Word, Excel, Outlook and Internet Explorer files before running this utility. This will open an Excel files with a prominent button labeled "Click to Load Narrative1 add-ins". After this utility runs, it will automatically close Word and Excel. Sometimes virus software will prevent Microsoft Word or Excel to use the Narrative1 add-ins. In this case, you will need to manually enable the add-ins and change your virus software's protection settings. For information about enabling add-ins with some common virus software programs, follow these links: Norton AntiVirus Plug-in for Microsoft Office Kaspersky To manually enable Narrative1 add-ins, follow the instructions below. NOTE: Only do this if the above method does not work for you. In Microsoft Word 2003
In Microsoft Excel 2003
In Microsoft Word 2007 and Later
In Microsoft Excel 2007 and Later
Occasionally you will need to restart either Word or Excel following the manual selection of add-ins. Top Share Comps There are two tools to share comps: Percent Values Not Displaying in Grid Percent office not showing % office not showing Occasionally, when a user accesses comps in the Sales Grid or copies of the Sales Grid, the Percent Office field does not display. This phenomenon occurs because the Microsoft Excel cells are not formatted to display values stored as percentages. To remedy this, the cell formats must be changed. In Microsoft Excel 2003 or earlier
| We Want Your Feed Back and Ideas! Screen shots shown here may be slightly different than your version of Excel N1Appraisal.xls |