ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Does the order of worksheets matter ? (https://www.excelbanter.com/excel-worksheet-functions/270898-does-order-worksheets-matter.html)

kittronald August 20th 11 02:01 AM

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.



Don Guillett[_2_] August 20th 11 06:56 PM

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


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com