| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating time
When I am working on a w/book ,status bar indicating calculating 5% .........,
..Can I identify the formula or anything which is causing this calculating time more. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200512/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating time
Look at
http://www.decisionmodels.com/index.htm first. If you can't find it manually, buy the FastExcel analyzer to locate the problem -- Kind regards, Niek Otten "T.K.RAJU via OfficeKB.com" <u16627@uwe wrote in message news:59652557d3d66@uwe... When I am working on a w/book ,status bar indicating calculating 5% ........., .Can I identify the formula or anything which is causing this calculating time more. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200512/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating time
One of my macro is taking about 10minutes to execute.Is it problem of my
macro code or my system,or my excel.The macro is updating 85 w/sheets,with a main sheet data and post them in all 85 w/sheets(one row of 5 cell values). Niek Otten wrote: Look at http://www.decisionmodels.com/index.htm first. If you can't find it manually, buy the FastExcel analyzer to locate the problem When I am working on a w/book ,status bar indicating calculating 5% ........., .Can I identify the formula or anything which is causing this calculating time more. -- Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculating time
Post the code of your macro here
-- Kind regards, Niek Otten "T.K.RAJU via OfficeKB.com" <u16627@uwe wrote in message news:5975887e9a974@uwe... One of my macro is taking about 10minutes to execute.Is it problem of my macro code or my system,or my excel.The macro is updating 85 w/sheets,with a main sheet data and post them in all 85 w/sheets(one row of 5 cell values). Niek Otten wrote: Look at http://www.decisionmodels.com/index.htm first. If you can't find it manually, buy the FastExcel analyzer to locate the problem When I am working on a w/book ,status bar indicating calculating 5% ........., .Can I identify the formula or anything which is causing this calculating time more. -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating time | New Users to Excel | |||
| help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
| Time Sheets | New Users to Excel | |||
| Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
| calculating with a time format cell | Excel Worksheet Functions | |||
Hybrid Mode
