主题：在表内"添加多行"速度极慢

斑竹:在表内"添加多行"速度极慢,如添加300行,要等5分钟,刚开始以为死机,终止,后来硬着头皮等足足5分钟才出来,何因,表有25列.

试过,在一个只有3列的表内添加2000行,速度还可以的.

发文件看看

[这个贴子最后由东方易在 2007/01/29 11:24pm 第 1 次编辑]

10个列内应用了刷新公式egd文件下载

斑竹看看

If([天格]= 1,"木",If([天格]= 11,"木",If([天格]= 21,"木",If([天格]= 31,"木",If([天格]= 41,"木",If([天格]= 51,"木",If([天格]= 61,"木",If([天格]= 71,"木",If([天格]= 81,"木",If([天格]= 2,"木",If([天格]= 12,"木",If([天格]= 22,"木",If([天格]= 32,"木",If([天格]= 42,"木",If([天格]= 52,"木",If([天格]= 62,"木",If([天格]= 72,"木",If([天格]= 3,"火",If([天格]= 13,"火",If([天格]= 23,"火",If([天格]= 33,"火",If([天格]= 43,"火",If([天格]= 53,"火",If([天格]= 63,"火",If([天格]= 73,"火",If([天格]= 4,"火",If([天格]= 14,"火",If([天格]= 24,"火",If([天格]= 34,"火",If([天格]= 44,"火",If([天格]= 54,"火",If([天格]= 64,"火",If([天格]= 74,"火",If([天格]= 5,"土",If([天格]= 15,"土",If([天格]= 25,"土",If([天格]= 35,"土",If([天格]= 45,"土",If([天格]= 55,"土",If([天格]= 65,"土",If([天格]= 75,"土",If([天格]= 6,"土",If([天格]= 16,"土",If([天格]= 26,"土",If([天格]= 36,"土",If([天格]= 46,"土",If([天格]= 56,"土",If([天格]= 66,"土",If([天格]= 76,"土",If([天格]= 7,"金",If([天格]= 17,"金",If([天格]= 27,"金",If([天格]= 37,"金",If([天格]= 47,"金",If([天格]= 57,"金",If([天格]= 67,"金",If([天格]= 77,"金",If([天格]= 8,"金",If([天格]= 18,"金",If([天格]= 28,"金",If([天格]= 38,"金",If([天格]= 48,"金",If([天格]= 58,"金",If([天格]= 68,"金",If([天格]= 78,"金",If([天格]= 9,"水",If([天格]= 19,"水",If([天格]= 29,"水",If([天格]= 39,"水",If([天格]= 49,"水",If([天格]= 59,"水",If([天格]= 69,"水",If([天格]= 79,"水",If([天格]= 10,"水",If([天格]= 20,"水",If([天格]= 30,"水",If([天格]= 40,"水",If([天格]= 50,"水",If([天格]= 60,"水",If([天格]= 70,"水",If([天格]= 80,"水",0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
这是一列的公式，何况还有五列这样的。

简化一下
if(right(text([天格]))="1" or right(text([天格]))="2","木",if(right(text([天格]))="3" or right(text([天格]))="4","火",if(right(text([天格]))="5" or right(text([天格]))="6","土",if(right(text([天格]))="7" or right(text([天格]))="8","金","水"))))

简化的好。
有规律可循，做公式时是应该多动下脑子，不然写这么长的公式麻烦不说，还影响速度。

呵。我也来一个。

mid("水木木火火土土金金水",Number(Right(text([天格]),1))*2,2)

[这个贴子最后由东方易在 2007/01/31 05:32pm 第 2 次编辑]

非常谢谢斑竹和GDXHQ，已经简化，速度快了。刚注册的，函数用不好，以后还要麻烦你。另外再请教：1 使用了多层表头，是否影响速度；2 在列内使用刷新公式，还是使用默认公式好，区别在那里，还是两个同时用。
请解答

谢谢GDXHQ