G
Guest
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.
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.