Forum Discussion
jens_i_m_j
Oct 03, 2019Copper Contributor
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
- HassakCopper ContributorI've this problem to
I don't know the reason
I had to make it manually with regrets - PascalKTeamIron ContributorWhat kind of formula are you using?
Maybe you have set calculating to manual? Try to hit F9 and check the result again