Does the order of worksheets matter ?


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.
 
Ad

Advertisements

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top