Linked cells not updating values after copy/paste into source table

Joined
Oct 9, 2018
Messages
45
Hi all!

One of my colleagues has issue since some days:

It's simpel: There are 2 Excel files: One to copy data from and Excel Masterdata file
The Masterdata file has 2 sheets: one with all the data and one with all the data but with linked cells to the first sheet.

AsWas: You could copy a range of data and paste it into the other workbook in data sheet. In the sheet with linked cells these cells were updated with the new values.

AsIs: We do the same thing but now values in the linked cells aren't updating anymore! Only if you open each cell separately or use Text To Columns in these columns, the links show their values. Otherwise they are just showing nothing. Formats of the linked cells and data cells are the same... Calculation mode is Automatic... I'm out of ideas... Please help!

Kind regards,
Roy
 
Last edited:

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Joined
Oct 9, 2018
Messages
45
Also, when I Enter a linked cell, there is a small function button coming next to it. When I click it, it show the option "Overwrite all cells in this column with this formula.". When I click on that option all cells are showing their values. Which I don't understand because they already contained that formula...
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,100,053
Messages
5,472,191
Members
406,808
Latest member
Pocher

This Week's Hot Topics

Top