cell show no value when open sheet on another computer, but value appears when save again

[shoot for moon]

Hi,

when I open my sheet on another computer, all cell value which contain formula show no value. just blank. formula is link to same workbook on different tab. when I save as again on my desktop, all value appears. excel 2007 is using.

any thought, Thanks for help.

[aworfolk]

When you open it up try hiting the F9 key to calculate the workbook.

[shoot for moon]

Tried, didn't work

[aworfolk]

Can you paste the formula so i can take a look at what it is doing to see if there is any thing up with it. Also the informtaion on the other tab is it calculated by a formula of so does it refrence anything else.