Hi JulieD;

Right click somewhere in the returned range and select
Data Range Properties. You will find the options there to
turn it off.

Thanks,

Greg
-----Original Message-----
Hi

i have a spreadsheet that draws information from an
access database and then
is "saved as" a new workbook - i would like to
(programmatically) break the
link (ie untick save query definition) after the save
as. I've done a
google search and found a post by Tom Ogilvy that
mentions a code solution
but i couldn't find it anywhere.

if this is not possible any other "workarounds"?
Thanks.

Cheers
JulieD


.