Does the order of worksheets matter ?

  • Thread starter Thread starter kittronald
  • Start date Start date
K

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.
 
    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.
Click to expand...

No
 
Back
Top