Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
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 256 cells, this is an array of 2,560,000 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 Essentials. However, Jet Essentials 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 Jet Reports 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
Have more questions? Submit a request

Comments