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?