excel limitations

I heard excel can calculate 1 million functions in a second.One of my
worksheet contains 623 formulas and about 26 names(function based),which is
taking about 20-25 seconds to calculate active worksheet.Database sheet also
contains data in 150 rows and 15 columns.There are no hyperlinks in that
sheet it depends only on one othersheet which is databse sheet.Anybody plese
clarify why so much of time it is taking?

Hello

I think that that calculation should be executed instantly, more or less, so
there must be something wrong. A few suggestions:

1) Make sure you don't have circular references in your calculations (excel
usually alert you for that, but if you don´t correct it may slow the process
down
2) Have you opened all the worksheets and databases that are needed for the
calculation open? If not you may get slow calculation due to a slow hard-disk
or a slow networkconnection

Kind regards Marcus

"TUNGANA KURMA RAJU" wrote:

> I heard excel can calculate 1 million functions in a second.One of my
> worksheet contains 623 formulas and about 26 names(function based),which is
> taking about 20-25 seconds to calculate active worksheet.Database sheet also
> contains data in 150 rows and 15 columns.There are no hyperlinks in that
> sheet it depends only on one othersheet which is databse sheet.Anybody plese
> clarify why so much of time it is taking?

What do you mean with 26 names, function based? Are they User Defined
Functions?
If so, post the code so we can look for performance problems

In general, for speed tips, visit

www.decisionmodels.com

--
Kind regards,

Niek Otten

"TUNGANA KURMA RAJU" <TUNGANAKURMARAJU@discussions.microsoft.com> wrote in
message news:D2DE6575-A798-46F9-B1C2-890F6C947B07@microsoft.com...
>I heard excel can calculate 1 million functions in a second.One of my
> worksheet contains 623 formulas and about 26 names(function based),which
> is
> taking about 20-25 seconds to calculate active worksheet.Database sheet
> also
> contains data in 150 rows and 15 columns.There are no hyperlinks in that
> sheet it depends only on one othersheet which is databse sheet.Anybody
> plese
> clarify why so much of time it is taking?

Thanks,My workbook contains 4 sheets,there are no circular references.sheet 1
is query sheet where all 623 formulas and 26 names based on functions and all
function ranges in this sheet are 1:1000(rows) and columns in some
cases.sheet 2 is database contains data in 150rows and 15 columns.around 15
pictures based on a vba code.Whenever I opened this workbook natually all
worksheets are in open condition.sheet 3 is helper sheet for some finctions
in sheet 1.sheet 4 is all formulas printout for viewing what are these 623
formulas in worksheet1.

"Marcus Ahlbäck" wrote:

> Hello
>
> I think that that calculation should be executed instantly, more or less, so
> there must be something wrong. A few suggestions:
>
> 1) Make sure you don't have circular references in your calculations (excel
> usually alert you for that, but if you don´t correct it may slow the process
> down
> 2) Have you opened all the worksheets and databases that are needed for the
> calculation open? If not you may get slow calculation due to a slow hard-disk
> or a slow networkconnection
>
> Kind regards Marcus
>
> "TUNGANA KURMA RAJU" wrote:
>
> > I heard excel can calculate 1 million functions in a second.One of my
> > worksheet contains 623 formulas and about 26 names(function based),which is
> > taking about 20-25 seconds to calculate active worksheet.Database sheet also
> > contains data in 150 rows and 15 columns.There are no hyperlinks in that
> > sheet it depends only on one othersheet which is databse sheet.Anybody plese
> > clarify why so much of time it is taking?