|It would be impossible for us to duplicate your exact environment in an attempt to replicate the error. I just linked over 30,000 cells from 2 different workbooks and had no problem bringing in the data.|
That said, I have a question:
You said that you are trying to "Import Range A1:A20000 usng the above formula ".
The problem I see is that the formula will only import the data from A1 since you have the reference locked with the $.
If you drag this down, it's just going to repeat the same formula over and over again.
Are you sure that that is the formula you are using?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.