ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   enable automatic refresh (https://www.excelbanter.com/excel-discussion-misc-queries/191916-enable-automatic-refresh.html)

makulski

enable automatic refresh
 
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


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com