# Order of calculation

1. ## Order of calculation

Does anyone know the criteria Excel uses to determine what order to calulate
cells in?

I have several workbooks which contain user-defined functions (contained in
an add-in) as formulas and can put a break-point in the add-in to see the
order in which the cells are calculated. These functions are only called when
Excel calculates the cell in which one appears and none of them depend on the
calculation of other cells.

However, the order of calulation Excel uses differs from workbook to workbook.

In one, it starts in the cell in the right-most column and the bottom-most
row and goes up the column to the top, then starts in the bottom-most cell of
the next column to the left.

In another, it starts in the cell in the top row of the right-most column
and goes along the row to the left and then when it has done the whole row,
drops down a row and starts again in the right-most cell.

I am trying make the user-defined function code more efficient and to know
what order Excel will calculate in would be immensely helpful.

Thanks,
Rosemary

2. ## Re: Order of calculation

Hi Rosemary,

Maybe this is of help:

http://msdn.microsoft.com/library/de...c_xlrecalc.asp

--
Kind regards,

Niek Otten

"RW" <RW@discussions.microsoft.com> wrote in message
news:05D17767-8048-4C95-84D7-DC4E260F1AE4@microsoft.com...
> Does anyone know the criteria Excel uses to determine what order to
> calulate
> cells in?
>
> I have several workbooks which contain user-defined functions (contained
> in
> an add-in) as formulas and can put a break-point in the add-in to see the
> order in which the cells are calculated. These functions are only called
> when
> Excel calculates the cell in which one appears and none of them depend on
> the
> calculation of other cells.
>
> However, the order of calulation Excel uses differs from workbook to
> workbook.
>
> In one, it starts in the cell in the right-most column and the bottom-most
> row and goes up the column to the top, then starts in the bottom-most cell
> of
> the next column to the left.
>
> In another, it starts in the cell in the top row of the right-most column
> and goes along the row to the left and then when it has done the whole
> row,
> drops down a row and starts again in the right-most cell.
>
> I am trying make the user-defined function code more efficient and to know
> what order Excel will calculate in would be immensely helpful.
>
> Thanks,
> Rosemary
>

3. ## Re: Order of calculation

Niek, thanks very much. The article explains a lot.
Rosemary

"Niek Otten" wrote:

> Hi Rosemary,
>
> Maybe this is of help:
>
> http://msdn.microsoft.com/library/de...c_xlrecalc.asp
>
> --
> Kind regards,
>
> Niek Otten
>
> "RW" <RW@discussions.microsoft.com> wrote in message
> news:05D17767-8048-4C95-84D7-DC4E260F1AE4@microsoft.com...
> > Does anyone know the criteria Excel uses to determine what order to
> > calulate
> > cells in?
> >
> > I have several workbooks which contain user-defined functions (contained
> > in
> > an add-in) as formulas and can put a break-point in the add-in to see the
> > order in which the cells are calculated. These functions are only called
> > when
> > Excel calculates the cell in which one appears and none of them depend on
> > the
> > calculation of other cells.
> >
> > However, the order of calulation Excel uses differs from workbook to
> > workbook.
> >
> > In one, it starts in the cell in the right-most column and the bottom-most
> > row and goes up the column to the top, then starts in the bottom-most cell
> > of
> > the next column to the left.
> >
> > In another, it starts in the cell in the top row of the right-most column
> > and goes along the row to the left and then when it has done the whole
> > row,
> > drops down a row and starts again in the right-most cell.
> >
> > I am trying make the user-defined function code more efficient and to know
> > what order Excel will calculate in would be immensely helpful.
> >
> > Thanks,
> > Rosemary
> >

>
>
>

4. ## Re: Order of calculation

You're welcome. If you are interested in Excel's calculation secrets, you
really should visit

www.decisionmodels.com

by Charles Williams

--
Kind regards,

Niek Otten

"RW" <RW@discussions.microsoft.com> wrote in message
news:C6490214-727D-42B8-934F-166C16C5C6BF@microsoft.com...
> Niek, thanks very much. The article explains a lot.
> Rosemary
>
> "Niek Otten" wrote:
>
>> Hi Rosemary,
>>
>> Maybe this is of help:
>>
>> http://msdn.microsoft.com/library/de...c_xlrecalc.asp
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "RW" <RW@discussions.microsoft.com> wrote in message
>> news:05D17767-8048-4C95-84D7-DC4E260F1AE4@microsoft.com...
>> > Does anyone know the criteria Excel uses to determine what order to
>> > calulate
>> > cells in?
>> >
>> > I have several workbooks which contain user-defined functions
>> > (contained
>> > in
>> > an add-in) as formulas and can put a break-point in the add-in to see
>> > the
>> > order in which the cells are calculated. These functions are only
>> > called
>> > when
>> > Excel calculates the cell in which one appears and none of them depend
>> > on
>> > the
>> > calculation of other cells.
>> >
>> > However, the order of calulation Excel uses differs from workbook to
>> > workbook.
>> >
>> > In one, it starts in the cell in the right-most column and the
>> > bottom-most
>> > row and goes up the column to the top, then starts in the bottom-most
>> > cell
>> > of
>> > the next column to the left.
>> >
>> > In another, it starts in the cell in the top row of the right-most
>> > column
>> > and goes along the row to the left and then when it has done the whole
>> > row,
>> > drops down a row and starts again in the right-most cell.
>> >
>> > I am trying make the user-defined function code more efficient and to
>> > know
>> > what order Excel will calculate in would be immensely helpful.
>> >
>> > Thanks,
>> > Rosemary
>> >

>>
>>
>>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1