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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,481
Members
412,596
Latest member
nickthebizz
Top