Excel Database query error

[DwayneS]

I wrote a spreadsheet app a couple years ago that has been used successfully since. I was making a change and now I'm getting an error I can't figure out.

There are several sheets. Each has a different database query (using ODBC to a VFoxpro database) plus pivot tables to summarize data for several reports.

I deleted a sheet and added a new one to do something new. Now I get this error when I open it:

Cannot find XLQuery.XLA!Register.dclick which is assigned to run each time [workbook name]People is opened.

I can't figure it out. Originally I had this workbook and another one set up to open as a set.

Can someone steer me to the right feature to fix this?

Dwayne Streeter, CPA, CITP

http://www.cpe-interactive.com

 

[NickPalmer]

I had this problem and looked through some other sites - found a reference to:

http://support.microsoft.com/default.aspx?scid=kb;en-us;277620

Which tells you that it is a version compatibility issue (as far as I can work out) that is solved by deleting some hidden names (there is code in there to do this). This seems to have worked - though I was a bit more conervative with my code than in the example using "xlquery" rather than "QUERY" (this may or may not be wise).

Anyway - good luck.

Nick