View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default 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