View Single Post
  #1   Report Post  
Old August 20th 11, 02:01 AM posted to microsoft.public.excel.worksheet.functions
kittronald kittronald is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 162
Default 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.