enable automatic refresh

M

makulski

There is a fairly elaborate question and answer called "How do break the link
from my excel workbook"
But my problem is the opposite.

I have a database query in my workbook. When I open the workbook I get a
"Query Refresh" pop up that says "This workbook contains queries blah blah
blah" and 2 buttons offering "Enable automatic refresh" "Disable automatic
refresh"

Can I answer this by default to "Enable", without it asking the question?
I've tried all of the combinations of Dataquery properties : Enable
background refresh ; Refresh data on file open, etc. But it always asks the
question on opening.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top