Knowledge Base

Sometimes what you may think is a table is really a “view”.

To see a “View” from within MS Query,
1. Go to the “Query Wizard – Choose Columns” panel,
2. Click the “Options” button,
3. Mark the “Views” on the “Table Options” panel,
4. Click “OK” and proceed.

Microsoft Access Database – General (Limitations prior to Access 2007) As with any application, there are always specifications and limitations as to what can be done. The following details the specifications stated in the Microsoft Access Help files for Microsoft Access 2000, XP and 2003 versions. Microsoft Access database (.mdb) 2 gigabytes Number of objects in a database 32,768 Modules 1,000 Number of characters in an object name 64 Number of characters in a password 14 Number of characters in a user name or group name 20 Number of concurrent users 255.

Xllerate^® creates an Access Database in an early version of Access to insure maximum compatibility for all systems.

To open an Xllerate^® created Access Database without converting the database, perform the following:
1. Select Open Database (user will see 2 options: “Open Database” and “Convert Database”),
2. Click the OK Button You may convert the Access Database to a more current version of Access (select “Convert Database” in step 1 above).

Remember to modify your Xllerate^® code to reference the newly converted database name (you will be required to rename the Access Database during the conversion process).

Most likely, someone attempted to manually move the Xllerate^® files from their required locations.

To “fix” this, you must “Repair” your installation. To Repair …
1. go to Start | Control Panel | Add / Remove Programs,
2. locate Xllerate in the list (it should be towards the bottom of the list),
3. click on the “click here for support information” hyperlink,
4. click the “Repair” button,
5. Wait until finished,
6. Open Excel, the error message should be gone.

The Xllerate.xla file is locked with a password and is not designed for Users to open. The adxloader.dll opens the Xllerate.xla file. To attach the adxloader.dll COM Add-in to your Excel…See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “COM”, “Add-in” and “attach”. To remove Xllerate^® from the regular “VBA” add-in list go to Tools | Add-ins and unmark Xllerate^®.

Excel starts acting strangely, is this an Xllerate^® problem? No.

The most common cause of general Excel “strangeness” is not enough system resources. The solution is to exit Excel and re-start Windows. If possible, don’t run any other applications while you use Excel. This problem is not caused by Xllerate^® per se. You may find that restarting Excel several times per day solves this type of problem. 

You may also temporarily “disable” Xllerate^® or set Xllerate^® not to load at each start up of Excel. Also, it’s a good idea to keep track of which add-in programs are installed (use the Add-Ins command on the Tools menu). In addition, you may have add-ins in your XLStart directory. These add-ins are loaded every time Excel starts, and may not even be listed in the Add-Ins dialog box. Add-ins consume memory and resources, and there is no need to load them if you don’t use them. Look to see whether you really need these programs to be loaded at startup, or contact your System Administrator if you you’re unfamiliar with this process.

For additional Excel Memory help, go to http://www.decisionmodels.com/memlimitsd.htm

Excel has this frozen menu problem sometimes, regardless of Xllerate^®.

Excel uses a “Excel.xlb” file to control the menu bar. You can locate that file and change the name to “backup.xlb”. Then restart Excel, this will force Excel to generate a new Excel.xlb which gives you a fresh start with the menu bar.

Please follow the steps below to give it a try:
1. Exit Excel
2. Excel.xlb can be found at C:\Documents and Settings\*USER_NAME*\Application Data\Microsoft\Excel (*USER_NAME* needs to be replaced by your actual user name. If you don’t know your username, go to C:\Documents and Settings\ and you should be able to recognize the folder of your user name, then go on to Application Data\Microsoft\Excel)
3. The file is a “.xlb” file but the “.xlb” extension may not show. So the file may look like a regular Excel file with a displayed name “Excel” (for Excel 2000) or “Excel11” (for Office 2003/XP).
4. Rename the file to “backup” or anything you like, then restart Excel.
5. You should get your Excel menu back. But if it does not work, you can always rename “backup.xlb” back to what it was before. This way you don’t lose anything.
6. The last resort is to simply uninstall and reinstall Office.

Read the article at http://www.jkp-ads.com/Articles/StartupProblems.asp

Go to Help | About Microsoft Office Excel. It is usually at the top of the displayed panel.

You can download a workbook from www.xlfdic.com for free. This workbook gives an example of how to use over 150 Excel formula functions.

Go to 1. www.ExcelUser.com OR 2. http://www.peltiertech.com/Excel/Charts/index.html

Check that your version of Excel has all patches and updates installed. You can do this by visiting Microsoft’s Office Update site at : http://office.microsoft.com/OfficeUpdate/default.aspx

You must purchase a license or uninstall Xllerate^®.

Download speeds vary depending on the distance between you and our web-site, and can also vary depending on the time of day.

1. Download again at a different time of day. The internet is generally slower during the afternoon & evening USA time. Try downloading early in the morning or late at night.

2. If you are still unable to download, we will forward you a disk via the US Mail.

The Xllerate^® program is just under 65 MB (megabytes). Of that, approx. 15 MB is the Xllerate^® Help and Reference Manual. Download Times: Dialup (56k) 71 minutes DSL/Cable (256k) 16 minutes DSL/Cable (768k) 5 minutes T1 (1.5MB) 3 minutes.

Most computers have .NET Framework 1.1 installed. Xllerate^® (as well as many newer software programs available in the market) require .NET Framework. To check if you have it installed, simply click on START, CONTROL PANEL, ADD OR REMOVE PROGRAMS and look for MICROSOFT .NET FRAMEWORK. If it is not there, download and install .NET Framework before you start to install Xllerate^®. To download NET Framework, go to the Microsoft Support site.

1. Click the “Start” button (in lower left corner of your screen);
2. Select “Programs”;
3. Select “Xllerate” from the programs list;
4. From the Xllerate list, select “License Manager”;
5. Select the “Internet Activate” icon.;
6. Enter the 15 digit license number we sent you in an email;
7. Press the “Activate” button.; Within a few moments, you will receive an activation complete message. 

Your Xllerate^® program is ready for unlimited use. See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “license activation”.

The download file has an EXE extension, denoting that it is an executable file. To download the EXE file, you may have to temporarily disable your firewall or antivirus software. After you downloaded the EXE file, double-click it to install all required files.

The file you downloaded will have a filename of “Xllerate_2.0.exe” (or similar), so to find the file try searching all your hard disks as follows:
1) Click Start, then choose Search > For Files or Folders…
2) In the Search for files or folders field, type “Xllerate*.exe” (without the quotes and note the use of a *)
3) In the Look in field, select Local Hard drives to or My Computer to search your entire computer
4) Click Search Now to begin the search. If no files are found then it is likely the download was not successful and you should download the file again from our web-site

To fix…1. go to Start | Control Panel | Add / Remove Programs, 2. locate Xllerate in the list (it should be towards the bottom of the list), 3. click on the “click here for support information” hyperlink, 4. click the “Repair” button, 5. Wait until finished, 6. Open Excel, Xllerate should be there.

The fix is simple. 
1. Log in as the User that cannot “see” Xllerate^® in their Excel (you may have to do this for every User that cannot “see” Xllerate^®),
2. go to Start | Control Panel | Add / Remove Programs,
3. locate Xllerate in the list (it should be towards the bottom of the list),
4. click on the “click here for support information” hyperlink,
5. click the “Repair” button,
6. Wait until finished,
7. Open Excel and Xllerate^® should be there.

The programs required are:
1. Excel 2007 and above (32-bit or 64-bit), VBA and Fm20.dll,
2. Windows Installer,
3. NET Framework (1.1.4322),
4. Administrator Rights for installing software See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “system requirements”.

At the end of the 30 days free use the software will be disabled. It will not disable Microsoft Excel, or prevent you using your computer, simply the Xllerate^® will be disabled. You will continue to receive a message telling you that the Xllerate^® evaluation period has ended.

You then have two choices:

1. Purchase a license to use Xllerate^®. For pricing & licensing information see our website 

2. Uninstall the software. For more details please see Uninstalling Xllerate^®.

Make sure that you haven’t substituted a letter “l” for a number “1” or a letter “o” for a number “0”. All Xllerate^® license keys are NUMERIC. The easiest way to make sure that you have the correct code is to copy and paste it directly from your confirmation email.

NET Framework is included with the Xllerate^® installation. However, to download NET Framework, go to the Microsoft Support Site,

Excel will (by default) show the User any programs that attempt to run a “macro”. The User must decide if the program is valid. Xllerate^® has a trusted certificate issued by VeriSign. For Xllerate^® to work correctly, you must mark the “Always trust macros from this source” and press the “Enable Macros” button.

This is normally caused by the Microsoft Scripting Runtime file not being properly registered on your PC. The error is completely unrelated to the add-in … but the add-in, like a lot of other software, requires the scripting runtime file to be installed correctly. Why is the scripting runtime not properly registered on your PC? A Google search of error 429 will show that there are thousands of reasons. However, Microsoft’s data access components (MDAC, DAO) seem to sometimes cause this error. The problem can normally be fixed by opening a command prompt (Start | Run) and typing REGSVR32 SCRRUN.DLL, and pressing enter. This registers the scripting runtime.

Xllerate^® makes modifications to the registry, installs files and a service to track license key usage. If you work for a company, some IT environments do not allow end users to install any software. If you attempt to install Xllerate^® and you do not have Administrative rights, the program will stop and let you know you do not have Administrative rights. If you have Administrative rights to your computer, you should have no issues installing Xllerate^®. If you are an individual and you are installing Xllerate^® on your personal computer, you should not have any issues.

From the Excel main toolbar, click View | Toolbars to check whether Xllerate^® is loaded but the toolbar is just hidden.

Xllerate^® is not designed to work on a Macintosh.

The software license you receive with Xllerate^® is perpetual per machine license. Any Users of the same machine may use the same license (i.e. you only need to purchase 1 copy of Xllerate^® for all Users of the same physical computer. This does NOT apply to server installs). Xllerate^® uses an online activation model to activate or transfer licenses. It is easy, self-serve, and real-time. Your machine needs to be online ONLY at the time of activation. See the Xllerate^® EULA for detail description of the Xllerate^® license.

1. Go to Start | Programs | Xllerate | License Manager
2. Go to the “Internet Deactivate” tab
3. Press the “De-activate” button
4. Download Xllerate^® to the new computer
5. Go to Start | Programs | Xllerate | License Manager
6. Enter your 15 digit License Key on the “Internet Activate” tab and you are done.

See also the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “license activation”.

We can help you, but will do so on a consulting fee basis only. There are no exceptions to the fee policy, no matter how simple the question may appear. We provide free support only on our add-in products (and only through email, support@xllerate.com).

Yes, you have free access to our technical & product support when you purchase or evaluate Xllerate^®. To contact support, please e-mail support@xllerate.com with a detailed report of the problem. We can only answer questions relating to using Xllerate^® and do not answer questions related to analysis or how to use Excel.

All e-mail inquiries are answered as soon as possible, generally within an hour if sent during normal business hours (US Central Time). If you are not receiving answers to Xllerate^® support questions it may be due to the reply mail being blocked by your mail server, whether it is erroneously flagged as spam, or being held on the server because xllerate.com is not on your “white list”. Please add Xllerate.com to your white list.

This is installation information that Xllerate^® support will use in debugging any issues you may have at installation. Xllerate^® does NOT collect any personal information or install any spyware on your computer.

Check for Windows updates at http://update.microsoft.com/

You can always share the output results of an Xllerate^® program with others. Note: the Xllerate^® formula functions (such as CreateDelimitedList and GetUserName) are only available to those Users who have Xllerate^®. Also, in order to “run” an Xllerate^® program, the other Users will need their own copy of Xllerate^®.

Data_Subtotals function was taking in excess of 2 minutes to run. Determined the issue was that the default printer on User’s computer was set to a printer that did not exist on network (or network was down). Several TLC functions use the printer driver to determine page breaks. Inserting page breaks calls for the page set-up function and uses the printer driver to do this. Try changing printer to another printer driver (like: Microsoft Document Imager) or by turning off the network connection. User should test by selecting another printer. Also, Users should determine if a more updated driver is available for their printer.

We have tested Xllerate^® with several add-ins successfully. The only issue we have found is with Google Desktop for Excel add-in. We received a request for a “password” when closing Excel. We have researched this issue on the web and found that other Excel Add-ins were experiencing the same issue. The issue was found to be caused by Google Desktop (or any add-in using mscoree.dll as it loader). The Google Desktop issue did not affect all machines. See Issue: “I get a prompt asking for a password when closing Xllerate^®. How do I get rid of this?” for the “fix”.

You can try. If it does not work, go to your computer’s “Start | Settings | Control Panel | Language & Regional Settings”, try setting it to English, and see if it works. If it works, then we are glad it will be able to assist you with your tasks. The bottom line is that you should make sure if works during the free trial period. If it works, then you can consider buying it. Otherwise, just uninstall it. Currently, Xllerate^® is available in English only.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “Prg_AutoOpen”, “Prg_AutoUpdate”, “Prg_AutoClose”, “Task Scheduler”

The “Review for Incomplete TLC Functions” process can be found on the menu bar under: Xllerate | About Xllerate | Additional Setup & Settings Information | Information – Incomplete TLC Functions OR click the “Eye Glasses” icon on the Xllerate Toolbar (The eye glasses stands for “take a look [i.e. “review”] at this program”).

On an Xllerate^® program worksheet, columns A through L will be resized to fit in the window. The Fit to Window function can be found on the menu bar under: Xllerate | About Xllerate | Additional Setup & Settings Information | Settings – Current Prg Fit to Window.

Xllerate^® sends emails from your “Default” email account. If you would like to send emails from a different account, you may enter the “FROM Email Address” in Variable #2 (wsV2x) of the Apps_Outlook | Send TLC function. If Variable #2 is left blank, Xllerate^® will send email(s) from the active (or default) Outlook Identity (See Xllerate | About Xllerate | License/Other | Mail Box Name to determine active Outlook Identity). If you enter a variable other than a blank or the default Outlook Identity, Xllerate^® will determine if the user has “rights” to access the designated Outlook Identity, then send the email from that email address. If the user does not have rights to the designated Outlook Identity, then Xllerate^® will send the email(s) from the active (or default) Outlook Identity.

Use the File_MultiFunction | Open TLC function. Put http:// in wsV2 and the website info in wsV3 (ex. finance.yahoo.com/q/ae?s=[RESEARCHSYMBOL] and replace [RESEARCHSYMBOL] with the stock symbol of your choice … like Q)

Add our free trial to your cart and check out. The trial version is good for 30 days.

This action retrieves “active” Outlook mail box information. The Outlook Mail Box function can be found on the menu bar under: Xllerate | About Xllerate | Additional Setup & Settings Information | Settings – Outlook Mail Box. NOTE: The answer is in the LOWER section of the panel.

1. Go to Start | Control Panel | Add / Remove Programs, 2. locate Xllerate in the list (it should be towards the bottom of the list), 3. click on the “Remove” button, 4. follow the panels until process is complete.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “user”, or “macro”

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “COM”, “Add-in” and “attach”

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “configure”, “pdf”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “Named Range”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “loop”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “trust”, “digital”, or “certificate”,

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “DSN”, “create”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “focus”, “contents”, “range”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “Insert”, “Text”, “cell”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “locate”, “keyword”, “TLC”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “Open”, “Close”, “event”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “VBA”.

The Xllerate^® program worksheet is protected by default. This action allows the user to convert the program worksheet to unprotected format. The Unprotect function can be found on the menu bar under: Xllerate | About Xllerate | Additional Setup & Settings Information | Settings – Current Prg Unprotect. For one time change, type the word “unprotect” in cell A1 of program worksheet.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “log activities”, “set up”.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “MS Query”. Also, go to the Training page on the Xllerate^® website…Locate the External Query lesson.

See the Xllerate^® Help Manual (go to Xllerate | Xllerate Help OR the click the white question mark on blue circle icon on the Xllerate Toolbar) and perform a search on the keyword “task scheduler”.

We have found that most problems with printing can be due to the way that the printer is set up on a network. Changing the way that your network printer is set up may resolve these printing errors.

There is an issue with Excel 2003 (11.5612.5660). Please upgrade to Service Pack 2. This should “fix” the problem. You can get the SP2 update from the Microsoft Support Site OR You can visit Microsoft’s Office Update site.

Xllerate^® uses another program called OTAsst.dll to access Outlook. If OTAsst is not registered properly, you may receive this type of message.

(A). Try re-registering OTAsst by…
1. going to Start | Control Panel | Add_Remove Programs,
2. locate Xllerate in the list (it should be towards the bottom of the list,
3. click on the “click here for support information” hyperlink,
4. click the “Repair” button. 5. Wait until finished and retry. If that does not work then,

(B) We tried testing Xllerate^® on 70 different system configurations, yours may be a “flavor” we did not test. However, don’t worry, we have a solution for you.
1. Go to c:\program files\xllerate <<<< (this may be different depending on where you installed Xllerate^®)
2. Look for the “bin” directory
3. Double click on the “bin” directory,
4. In the “bin” directory, you will find a .zip file named “ClickYesSetUp.zip”,
5. Unzip and install the program,
6. This program will place a small icon on the lower right of your screen,
7. When the icon has a check mark, it will automatically answer the Outlook warning messages,
8. When the icon has an X, it will not answer the Outlook warning messages. See the ClickYes Help for more information (see also http://www.contextmagic.com/express-clickyes/).

Excel 2000 only allows publishing of static web pages. If you are using Excel 2003/XP, make sure the web page name in Variable #3 (wsV3x) has an extension of .HTML or .HTM AND that you have rights to save a file to the directory indicated in Variable #2 (wsV2x).

If you have installed the Google desktop search software and you are using Excel it is highly likely that you will get a request for an Excel add-in password when you close Excel. Get a “Password Problem Fixer” program at http://www.add-ins.com/password_problem.htm. This program works in Excel 97, 2000, 2002, XP, 2003, and 2007.  

You can also perform the following step to remove the Google add-in from Excel…
1. Go to View | Toolbars | Customize,
2. Click the “Commands” tab,
3. Click “Tools” in the Categories list,
4. In the “Commands list” find “COM Add-ins” (about half way down),
5. Click on “COM Add-ins” and drag it up to an existing toolbar,
6. Click on the new “COM Add-Ins” button and remove any check mark next to “Google Desktop Office Addin”.

No, all help is provided in Xllerate^® in an electronic format. The Xllerate^® Help and Reference manual is over 800 pages. The Xllerate^® Introductory Training Manual (“The Basics”) is 70 pages. Also, There are 3 levels of help in Xllerate^®.

Level 1.
a. Keyword help to locate a TLC function (select Help from the MainMenu drop down list,
b. select a keyword or action from the drop down list,
c. continue refining your selection (using the same drop down list) until your desired function is located (i.e. the item in Column B will turn red).

Level 2.
Use “Help Tip” in cell A1. This will turn on the Help Tip comments on each variable of a new TLC function.

Level 3.
Select the Xllerate^® Help Manual. You will be taken to the subject closest to your current TLC function or other item.

Yes. You may set Excel’s calculation mode to “Manual”. See Tools_Options | Calculation in the Xllerate^® Help Manual for more information. WARNING: be sure to turn calculation back to “Automatic” when appropriate.

You may have set Excel’s calculation mode to “Manual” at a critical point in your program. See Tools_Options | Calculation in the Xllerate^® Help Manual for more information.

1. If you see these symptoms, it may be because Xllerate^® has been disabled. This sometimes happens in Excel 2002/XP/2003. This can be easily fixed. On the worksheet toolbar, click “Help | About Microsoft Excel”, then click the “Disabled Item” button, check to see if Xllerate^® has been disabled. If Xllerate^® is in there, “Enable” it.

2. You may have Xllerate^® “set” not to load (see the icon that looks like a diskette or looks like a dotted box with a red X). If the icon is set to a dotted box with a red X, Xllerate^® is set not to load at the startup of Excel. Click this icon and change it to a diskette and Xllerate^® will load at the startup of Excel.

1. There is a 30 days usage limitation.

2. There is a remainder message box indicating the number of days left in your evaluation period. If you are testing how Xllerate^® works with the Task Scheduler, you will have to answer the “Evaluation Period” message box manually. This message box will NOT display on a fully licensed version of Xllerate^®. Other than that, you are evaluating the full product, complete with the online help & tutorials available.

An Excel Add-in is a program designed to enhance Excel’s functionality. To Users, Xllerate^® appears to be an integral part of Excel.

Xllerate^® uses another program called OTAsst.dll to access Outlook. If OTAsst is not registered properly, you may receive this type of message.

A. Try re-registering OTAsst by…
1. going to Start | Control Panel | Add_Remove Programs,
2. locate Xllerate in the list (it should be towards the bottom of the list,
3. click on the “click here for support information” hyperlink,
4. click the “Repair” button.
5. Wait until finished and retry.

If that does not work then…
B. We tried testing Xllerate^® on 70 different system configurations, yours may be a “flavor” we did not test. However, don’t worry, we have a solution for you.
1. Go to c:\program files\xllerate <<<< (this may be different depending on where you installed Xllerate^®)
2. Look for the “bin” directory
3. Double click on the “bin” directory,
4. In the “bin” directory, you will find a .zip file named “ClickYesSetUp.zip”,
5. Unzip and install the program,
6. This program will place a small icon on the lower right of your screen,
7. When the icon has a check mark, it will automatically answer the Outlook warning messages,
8. When the icon has an X, it will not answer the Outlook warning messages. See the ClickYes Help for more information (see also http://www.contextmagic.com/express-clickyes/).

1. If you see these symptoms, it may be because the XllerateFunction.xls has been disabled. This sometimes happens in Excel 2002/XP/2003. This can be easily fixed. On the worksheet toolbar, click “Help | About Microsoft Excel”, then click the “Disabled Item” button, check to see if XllerateFunction.xls has been disabled. If Xllerate® is in there, “Enable” it. 
2. You may not have all of the information necessary to complete the formula function (see the Xllerate^® for more information).
3. One (or more) of the variables entered in the Xllerate^® formula function may be in error.

Xllerate^® is a COM Add-In. The files listed in the Tools Add-Ins list are Excel files with *.xla and *.xll extensions.

Xllerate^® was not designed to run from any other program other than Excel.

Xllerate^® does not work with Excel 97 or Excel 2000. There are no plans to create a version for Excel 97 or Excel 2000. Xllerate^® only works for Excel 2002, 2003, XP and 2007.

Currently, Xllerate^® only interfaces with Outlook. Future releases will include integration with other types of email accounts.

There are 3 levels of help in Xllerate^®. Level 1. Keyword help to locate a TLC function (select Help from the MainMenu drop down list, Select a keyword or action from the drop down list. Continue refining your selection (using the same drop down list) until your desired function is located (i.e. the item in Column B will turn red). Level 2. Use “Help Tip” in cell A1. This will turn on the Help Tip comments on each variable of a new TLC function. Level 3. Select the Xllerate^® Help Manual. You will be taken to the subject closest to your current TLC function or other item.

1. Go to Tools | Customize on the Worksheet Toolbar,
2. Select the Commands Tab,
3. Select Tools from the Categories List,
4. Select COM Add-Ins… from the Commands List,
5. With your mouse, pick up and move the COM Add-Ins… to an existing toolbar,
6. Release your mouse key…and the COM Add-Ins should be added to the selected toolbar,
7. Click on the COM Add-Ins…,
8. If the XllerateCOM is listed, then click the check box next to it,
9. Click the OK button and Xllerate® will install. 

You are done!, This panel is a display of all installed COM Add-Ins. If this does not work, see the instructions in “How to attach Xllerate^® to your Excel” in the Xllerate^® Help Manual.