Links refering to tablenames cannot be updated

Marianne_NL

New Member
Joined
Aug 18, 2020
Messages
4
Office Version
  1. 365
Platform
  1. 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?

1597757747858.png



1597757860860.png
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,119,174
Messages
5,576,534
Members
412,730
Latest member
Thundereagle
Top