External data changes not reflected

[busyman5_au]

I am frustrated by something that is probably simple and due to my lac
of knowledge...

I had some 10 rows of external data (a named range in anothe
spreadsheet) and I was copying it in just fine.

Then I extended the source to have 20 rows and changed the length o
the named range now when I refresh the data in the destination it onl
brings in the first 10 rows.

Even If I create a NEW desination workbook file it still doesn't pic
up my new BIGGER named range definition(so it isn't something local t
the WKS file)

I presume it muct be keeping some definition around in cache or in
file or something.

So ..... how do I clear things to ensure that it goes all the way bac
to the source and picks up the latest definition?

I am using Excel 2002 (in case this matters)


Also related Q ... what is the correct way of defining links so tha
they can be moved easily later on (and where do I read about how to d
this).

THANKS !!

 

[Don Guillett]

Always nice to show us your coding efforts for comments and how your range
is defined.