Forum Discussion

jens_i_m_j's avatar
jens_i_m_j
Copper Contributor
Oct 03, 2019

cell reference returns wrong value

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 Replies

  • Hassak's avatar
    Hassak
    Copper Contributor
    I've this problem to
    I don't know the reason
    I had to make it manually with regrets
  • PascalKTeam's avatar
    PascalKTeam
    Iron Contributor
    What kind of formula are you using?
    Maybe you have set calculating to manual? Try to hit F9 and check the result again

Resources