Error 2869 when installing FetchXL.
Windows Vista User Account Control (UAC) is interfering with FetchXL install. To disable Windows Vista UAC: From the Control Panel select Administive Tools...

FetchXL is no longer loading in Excel.
A common cause of the FetchXL toolbar and menu disappearing is the unloading of the FetchXL Add-In from Excel. To load the FetchXL Add-In, please follow the directions...

#Value! Errors After Upgrading from FetchXL 1.0
If you are upgrading from FetchXL 1.0, please note that FetchXL 1.5 and later will require some action on your part each time you open a file with formulas created in...

Using Excel Dates in the Fetch Function
When using time series datapoints in FetchXL, the date must be passed as text for our server to understand your request (i.e. 1/1/07 or 1/1/2007). If you are linking...

Where Did My FetchXL Toolbar Go?
A common cause of the FetchXL Toolbar disappearing is the unloading of the FetchXL Add-In from Excel. To load the FetchXL Add-In, please follow the directions below for...

Worksheet cells do not update, even non-FetchXL cells.
By default, Microsoft Excel automatically recalculates formulas when the cells that the formula depends on have changed. However, workbooks can be set to Manual...

=FETCH returns #N/A! in all cells even though FetchXL toolbar and menu area visible
If you have Norton AntiVirus and the =FETCH function always returns #NA! in cells even though the FetchXL toolbar, menu, Formula Builder, Screen Builder and other FetchXL...

Firewall and Proxy Settings
For the FetchXL Add-In to work, it needs to connect to the FetchXL data server on the Internet. Some customers may have firewalls and/or proxy servers that interfere with...

Are inactive compabies available in the Hemscott dataset?
Hemscott removes all inactive companies from their dataset following their de-listing. As such, only active companies are included in the Hemscott dataset.

Why is the Hemscott data prior to 2000 rounded in thousands?
Prior to 2000, Hemscott's policy was to round their data in thousands. As a result, if a company actually filed revenue of 1,234,567 Hemscott would consider this to the...

Refresh results in "Calculate method of Range class failed"
If FetchXL (global or selection) refresh results in an error message starting with line: System.Runtime.InteropServices.COMException (0x800A03EC): Calculate method of...

Enable/disable FetchXL logging
To enable FetchXL logging: 1) Open the file "C:\Program Files\FetchXL\Fetch.Addin.Xll.config" in a text editor such as Windows Notepad 2) Find the line...

What does NE, NA, NC and NS stand for?
NA = Not Applicable NE = Negative Earnings, negates a calculation NC = Cannot be calculated NS = Negative Stockholders Equity, negates a...

What Items are Included in the Hemscott Datapoints?
This article is protected and thus no preview is available.