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