I'd formula / links thru different worksheet in my excel file. Some data did not automatically updated. Even I use the "Calc NOW" (F9) function from the Tools/Options, still no response at all.

My colleage said there is a formula/memory limit in each excel file. He guess my file is over the limit.

Is that true? So there will be no solution?