| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Error in For Each Worksheet Loop
Thanks for posting back.
Buck wrote: It refreshes the sheets in the order they appear in the sheet tabs. If Sheet1 has a pivot-table based on query-table data in sheet2 then 'Refreshall' updates the pivot-table and then the query-table, which means changes in the query-table data aren't reflected in the pivot-table. Looks like you would either have to move sheets with external links to the front of the workbook or run the 'Refreshall' twice so the pivot-table can pick up the new data on the second pass. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop type formula - no Macro | Excel Discussion (Misc queries) | |||
| Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
| Help - Type mismatch when running loop with strings from arrays | Excel Programming | |||
| Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
| Copying data to another worksheet gives "Type Mismatch" error | Excel Programming | |||
Threaded Mode
