| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Refresh all but 1st sheet
Should't this work? Also, it ask to inmport text, how to say "yes" evertime?
Text name will be different ever time. Sub Refreshall () For i = 2 To Sheets.Count With Active.Sheet Selection.QueryTable.Refresh BackgroundQuery:=False Next i End Sub Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically updating sheet upon data Refresh All? | Excel Discussion (Misc queries) | |||
| refresh sheet data | Excel Discussion (Misc queries) | |||
| Refresh Pivot in Locked Sheet? | Excel Discussion (Misc queries) | |||
| Refresh data from an Excel sheet | Excel Worksheet Functions | |||
| refresh external data on a protected sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
