Posted to microsoft.public.excel.programming

external usenet poster

Posts: 24

Which sheet gets calculated first for iterations?

I have a workbook that has 5 sheets, each of which have cells that
refer to one another. It is important that one sheet be fully
calculated, then the next, and so on. Does excel calculate sheets in
order (i.e. 1 to 5) or does it do something else?

I am running it with a manual calculations and iterations allowed. I am
using Excel 2002.

Thanks,

Abe

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot table, IF function, calculated item versus calculated field	NomadPurple	Excel Discussion (Misc queries)	1	March 9th 10 03:17 PM
Pivot Table Calculated Field Row - (For Balance Sheet)	Mathew P Bennett	Excel Discussion (Misc queries)	0	July 22nd 08 09:48 PM
# of iterations	Rick	Excel Worksheet Functions	1	May 10th 07 04:41 PM
pivot table formulas for calculated field or calculated item	Vicky	Excel Discussion (Misc queries)	3	June 6th 06 05:06 AM
Forcing VBA to wait until sheet completely calculated	Nirmal Singh[_2_]	Excel Programming	3	May 16th 06 04:10 PM

All times are GMT +1. The time now is 04:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us