cell reference returns wrong value

[jens_i_m_j]

Hi

Has anybody experienced this: a simple reference to another excel spreadsheet tab returns a wrong value ?

• There's no error message
• I tried to recalculate, but the result is the same
• it only happens when I reference this particular tab - it is similar to 7 others, where the reference returns the correct value
• when I delete the reference and write It again, it returns the correct value
• the cell reference is identical to the ones that returns the correct value - including format etc.

/jens

[#2]

What kind of formula are you using?
Maybe you have set calculating to manual? Try to hit F9 and check the result again

[#3]

I've this problem to
I don't know the reason
I had to make it manually with regrets