Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Windows XP
Office 2003 I have written a simple macro that refreshes all my external data (database queries) in my spreadsheet. This macro is supposed to refresh everything. Most of the time this is the case. Sometimes for some reason a dataset or two that should get refreshed does not get refreshed. If one or two has not updated after the macro runs, I can manually tell it to refresh and it will work. Anyone have any idea why the refresh all macro sometimes skips a data set and/or how to correct it? Is there some sort of a timeout or something that might be causing this? Here is my macro: Sub Macro3() Application.DisplayAlerts = False Sheets("Sheet1").Select Range("A1").Select ActiveWorkbook.RefreshAll Application.DisplayAlerts = True MsgBox("Refresh Complete") End Sub Thanks, -Lou Sanderson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
link to combobox | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Editing a simple macro | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) |