Does the order of worksheets matter ?

[kittronald]

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.

 

[Don Guillett]

    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