I am not able to select any refresh options, but I didn't think I'd be able
to. The add-in is 3rd party and is password protected, so I don't know how
it works. What is does is provide functions that (I assume) query the
database and provide the data. This is only supposed to happen when the
sheet calculates, but as I said, it recently changed. This only seems to be
a problem on certain sheets, and when it is done the workbook has not been
completely calculated (at least I still see Calculate at the bottom left of
the screen). There are also no Workbook_Open procedures. Thanks for the
suggestions...any more thoughts?

"JakeyC" wrote in message
oups.com...
I could be wrong, but I don't think stopping calculation will stop
automatic refreshes of external queries. See if you can right-click the
data and select 'properties' - if so, disable automatic refresh.
Otherwise, check what your add-in has actually done and finally check
that the workbook has no code that runs on opening that could revert
excel to your original settings.