Hi all,
I'm designing an Excel template mainly use SUMIF, VLOOKUP to extract data
from several data sheets in the workbook. After that I duplicated it
repeatedly to produce 20 sheets in same format. Each time I produced a new
sheet I pressed F9 to recalculated all cells and was fine for the first 15
sheets. However, when I produced the 16th sheet and pressed F9, the whole
workbook get recalculated but the 'Calculate' message was left on the status
bar thereafter. FYI, my workbook is about 9MB in size.
Could you please tell me where I made a mistake that caused this annoying
message? How can I tackle this?
Appreciate if someone could help me out with it.

Regards
,
Steve C.

Steve, have a look here for why this maybe happing

http://www.decisionmodels.com/calcsecretsf.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Steve C." wrote in message
...
Hi all,
I'm designing an Excel template mainly use SUMIF, VLOOKUP to extract data
from several data sheets in the workbook. After that I duplicated it
repeatedly to produce 20 sheets in same format. Each time I produced a new
sheet I pressed F9 to recalculated all cells and was fine for the first 15
sheets. However, when I produced the 16th sheet and pressed F9, the whole
workbook get recalculated but the 'Calculate' message was left on the
status
bar thereafter. FYI, my workbook is about 9MB in size.
Could you please tell me where I made a mistake that caused this annoying
message? How can I tackle this?
Appreciate if someone could help me out with it.

Regards
,
Steve C.

Hi Paul, many thanks for your advice. Have a nice day!

"Paul B" wrote:

Steve, have a look here for why this maybe happing

http://www.decisionmodels.com/calcsecretsf.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Steve C." wrote in message
...
Hi all,
I'm designing an Excel template mainly use SUMIF, VLOOKUP to extract data
from several data sheets in the workbook. After that I duplicated it
repeatedly to produce 20 sheets in same format. Each time I produced a new
sheet I pressed F9 to recalculated all cells and was fine for the first 15
sheets. However, when I produced the 16th sheet and pressed F9, the whole
workbook get recalculated but the 'Calculate' message was left on the
status
bar thereafter. FYI, my workbook is about 9MB in size.
Could you please tell me where I made a mistake that caused this annoying
message? How can I tackle this?
Appreciate if someone could help me out with it.

Regards
,
Steve C.