software

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
www.officekb.com/Uwe/Forums.a...excel/200512/1

Look at

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

quot;T.K.RAJU via OfficeKB.comquot; lt;u16627@uwegt; wrote in message
news:59652557d3d66@uwe...
gt; When I am working on a w/book ,status bar indicating calculating 5%
gt; .........,
gt; .Can I identify the formula or anything which is causing this calculating
gt; time more.
gt;
gt; --
gt; Message posted via OfficeKB.com
gt; www.officekb.com/Uwe/Forums.a...excel/200512/1
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:
gt;Look at
gt;
gt;www.decisionmodels.com/index.htm
gt;
gt;first. If you can't find it manually, buy the FastExcel analyzer to locate
gt;the problem
gt;
gt;gt; When I am working on a w/book ,status bar indicating calculating 5%
gt;gt; .........,
gt;gt; .Can I identify the formula or anything which is causing this calculating
gt;gt; time more.

--
Message posted via www.officekb.com

Post the code of your macro here

--
Kind regards,

Niek Otten

quot;T.K.RAJU via OfficeKB.comquot; lt;u16627@uwegt; wrote in message
news:5975887e9a974@uwe...
gt; One of my macro is taking about 10minutes to execute.Is it problem of my
gt; macro code or my system,or my excel.The macro is updating 85 w/sheets,with
gt; a
gt; main sheet data and post them in all 85 w/sheets(one row of 5 cell
gt; values).
gt;
gt; Niek Otten wrote:
gt;gt;Look at
gt;gt;
gt;gt;www.decisionmodels.com/index.htm
gt;gt;
gt;gt;first. If you can't find it manually, buy the FastExcel analyzer to locate
gt;gt;the problem
gt;gt;
gt;gt;gt; When I am working on a w/book ,status bar indicating calculating 5%
gt;gt;gt; .........,
gt;gt;gt; .Can I identify the formula or anything which is causing this
gt;gt;gt; calculating
gt;gt;gt; time more.
gt;
gt; --
gt; Message posted via www.officekb.com