I have a couple of macros that I originally set up in Excel 2007 for PC that pull data from a web query and use Application.OnTime in a Workbook_Open event to refresh and save at a certain time automatically every night (it uses task scheduler to automatically open Excel daily). I'm trying to accomplish this in 2011 for mac and am being thwarted by the need to re-enable data connections every time the workbook opens.
I've tried recording a macro while the "enable content" security warning that pops up when you open the workbook is still active, but nothing records. I can't find any settings to permanently enable web queries.
Is there a way to permanently enable the content? A way to write the re-enabling into a macro?
Any help would be much appreciated!