Error referencing linked dynamic range
Hi,
I'm having trouble with a link I've set up in a calculation.
I have two rather large spreadsheets (Excel 2003 ~ 10MB each):
A (MASTER Pricing.xls) and B (Myfile.xls).
In A I have a named range (Tier_Data) that uses the offset formula and
counta in order to be dynamic (if you add any rows or columns, the range
expands).
In B I have a formula that looks values up from the range. eg:
=VLOOKUP($C11,'C:\MASTER Pricing.xls'!Tier_Data,2,0)
This works beautifully when both workbooks are open, however if I do not
open A and try to update links or calculate cells in B, it gives me an error.
Updating gives me 'Error: Undefined or non-ractangular name'
Calculating says it cannot find 'Tier_Data' on 'MASTER Pricing.xls'
Can someone please advise on how to get around this problem please?
Many thanks,
Basil
|