calculating time

  • Thread starter T.K.RAJU via OfficeKB.com
  • Start date
T

T.K.RAJU via OfficeKB.com

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.
 
T

T.K.RAJU via OfficeKB.com

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).
 
Top