Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Filter Ranges and Excel

Always enclose in quotes any ranges containing ".." that you type directly into a formula or into a parameter with the Excel function wizard.

Without quotes, Excel may interpret your range as a set of values from the worksheet.

For example, if you enter "49950..59950" (including the quotes), Excel will interpret the filter as a simple text string.  Without the quotes, 49950..59950 means all the values in rows 49950 through 59950.  Since each row has 16,384 cells, this is an array of over 163 MILLION cells.

In this example, if you omit the quotes, Excel will go into a very long calculation.  Usually the only way to stop this calculation is to end the process.  Consult your IT expert for instruction on how to end a process on your computer.


This functionality of Excel has nothing to do with Jet Reports.  However, Jet Reports users are more likely to accidentally enter a range that causes Excel to perform a long calculation because of the way ranges of values are entered using ".."

These range calculations are a basic feature of Excel and there is no way for the Jet Excel add-in to change this behavior.

If a formula references a cell that contains a range with ".." you do not need to type the quotes into the cell.  The quotes are only required when you put the range directly into a function parameter.

Was this article helpful?
0 out of 0 found this helpful