When you click to update the content of a worksheet, the program requests for the corresponding data to be loaded from the database. This data is loaded by portions, i.e. batches. Each batch consists of a number of rows, and this number varies depending on the setting in the Setup dialog box4 (see the slider in the following figure). The lowest position of the slider corresponds to the slowest data loading speed, i.e. the fewest possible number of rows will be loaded to the worksheet at a time. Move the slider up to increase the speed.


The gauge is divided into 11 points [0 – 10], each of which corresponds to a particular value of the variable UserPreference. This variable is used in a formula that calculates the number of rows to be loaded at a time (RowCount)—see Formula 1 later. The lowest point [0] corresponds to UserPreference=1, [1] – UserPreference=100, [2] – UserPreference=200, …, [10] – UserPreference=1000. Another variable used in the formula is the number of columns currently being visible in the worksheet (ColumnsVisible). (Data for the hidden columns is not loaded.)

The operation min(a1, a2) in the formula compares its two arguments and returns the smaller value. (Thus, the number of rows loaded at a time cannot be more than 500.)

The operation max(a1, a2) compares its two arguments and returns the larger value. (Thus, the number of rows loaded at a time cannot be less than 1.)

Example. Our worksheet contains seven visible columns. The data loading speed is set to “Slow connection (dial-up)” (see the preceding figure), i.e. the point [1] that corresponds to UserPreference=100. Thus,