Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel limitations
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel limitations
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" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel limitations
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Limitations od Excel Sheet | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Autofilter - limitations? | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |