Does the order of worksheets matter ?
 

Scenario:

A workbook has multiple worksheets.

Sheet1 and Sheet3 contain data only, no formulas.

Sheet2 and Sheet4 contain formulas that reference the data on Sheet1
and Sheet3.

Is there a performance difference in the ordering of worksheets ?

For example, forward referencing vs. backward referencing.



- Ronald K.

Does the order of worksheets matter ?
 

On Aug 19, 8:01*pm, "kittronald" wrote:
* * Scenario:

* * * * A workbook has multiple worksheets.

* * * * Sheet1 and Sheet3 contain data only, no formulas.

* * * * Sheet2 and Sheet4 contain formulas that reference the data on Sheet1
and Sheet3.

* * Is there a performance difference in the ordering of worksheets ?

* * For example, forward referencing vs. backward referencing.

- Ronald K.

No