Marianne_NL
New Member
- Joined
- Aug 18, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
It seems that external links to figures that are in a tableformat in the source file give problems with updating when the tablename is used in the external link.
See pictures below:
Both column A and C refer to the same source data as column E and F.
For A and C the tablename is used in the link (...!Tabel1[Kolom4])
whereas column E and F use cel references (see second picture)
When updating the links column A and C give an error message (#VERW! = #REF!)
I know you can inactivate the option to use tablenames in formulas (through: File - Options - Formulas and uncheck the box "Use table names in formulas") - but I actually find it quite annoying to inactivate this as using tablenames make formulas much more easy to read.
Does anybody recognize this problem? And has anybody another solution?
See pictures below:
Both column A and C refer to the same source data as column E and F.
For A and C the tablename is used in the link (...!Tabel1[Kolom4])
whereas column E and F use cel references (see second picture)
When updating the links column A and C give an error message (#VERW! = #REF!)
I know you can inactivate the option to use tablenames in formulas (through: File - Options - Formulas and uncheck the box "Use table names in formulas") - but I actually find it quite annoying to inactivate this as using tablenames make formulas much more easy to read.
Does anybody recognize this problem? And has anybody another solution?