Johnny C
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
I have a file linked to another.
Nothing fancy, 3 rows 4 columns in columns D-G with the formula
copied down and across.
When I open the file (with the source closed) the data in columns D,E and G are fine, but the links in col F have a #DIV/0 error.
The source data is pasted as values.
I know I can stop it updating the links but what is going on?
Nothing fancy, 3 rows 4 columns in columns D-G with the formula
Code:
='F:\[Historic costs.xlsb]Historic costs'!B14When I open the file (with the source closed) the data in columns D,E and G are fine, but the links in col F have a #DIV/0 error.
The source data is pasted as values.
I know I can stop it updating the links but what is going on?
