Automation Error : The object invoked has disconnected from its client

[EliseFreedman]

Hi There

I have created a series of excel spreadsheets. Basically there is a master spreadsheet made up of data from a number of other spreadsheets(all consisting of imported data). The idea is that the users click a button on the master spreadsheet and the data is imported from our database application into all the spreadsheets and then the formulas on the master spreadsheet are calculated automatically.

This spreadsheet has worked 100% perfect on my pc. Yesterday I was explaining it to the users (on one of their PC's). Hit the button on the master spreadsheet and bang. Got a debug error which ive never come across before (shown in title). When I hit debug, the line

.refresh BackgroundQuery:=false

How can I fix this error. What I dont understand is why it happens on the other PC but runs perfectly on mine?

 

[xlbo]

check the ODBC connections on the computer - probably set up differently from yours.

Other option is that they do not have permissions on the tables - depends on how the ODBC is set up - whether it uses integrated security or a supplied userID & password

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[combo]

This article may be helpful.

combo