Thread: Cancel query
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Cancel query

hi,
are you using microsoft query????
if so then right click the query range and click data range properties.
on the property box, at the top, uncheck "save query definition"
chick ok. you will get a warning about permanently removing query. chick ok.
gone. non reversible.

Regards
FSt1

"Oldjay" wrote:

I have 2 sheets in a workbook that import data from an access on refresh. One
works and the other one doesn't. I keep getting "disk error". I would like to
delete the query and start over. How do I do this?