View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
den den is offline
external usenet poster
 
Posts: 2
Default Unwanted MS Acccess Query in Excel spreadsheet

I have a spreadsheet, in which there is a certain cell and if I enter a
value in that cell the spreadsheet trys to connect to a MS Access database.
I have removed every reference I can find to any MS Access query, but it
just keeps trying to update a MS Access query.

It refers to MS Access Query _ 4, I have looked all through my range name
references looking for this range name and it is not there. I have looked
through all my macros and VBA code in the spreadsheet and cannot find a
reference to a MS Access Query.

Anyone have any suggestions on how I can find the cause of this. It is not
supposed to be trying to get to a MS Access database at all, so I do not
where the query came from. It only happens if one particular cell on one
particular worksheet is changed.

Any suggestions appreciated.

Dennis