Speeding Up a Macro to control selections in a Slicer

[SpikeGiles]

I have a huge data set of sales by different product categories. Each category has a code and there is a large list of codes. I have a slicer to select the set of codes I wish to report on at any given time and I have created different macros to select different groups of codes for different reporting purposes. The VBA code that is generated by these macros lists every code in my data set with either a true or false attached, determining if that code is selected or not. Trouble is when I run a macro it seems to evaluate each code one at a time and refresh the report for each code. This causes the macro to take a inordinate amount of time to run. Is there a way to have the macro make all the selections in the slicer, but only update the report after all the codes have been either selected or not?

 

[bs0d]

I have a huge data set of sales by different product categories. Each category has a code and there is a large list of codes. I have a slicer to select the set of codes I wish to report on at any given time and I have created different macros to select different groups of codes for different reporting purposes. The VBA code that is generated by these macros lists every code in my data set with either a true or false attached, determining if that code is selected or not. Trouble is when I run a macro it seems to evaluate each code one at a time and refresh the report for each code. This causes the macro to take a inordinate amount of time to run. Is there a way to have the macro make all the selections in the slicer, but only update the report after all the codes have been either selected or not?

Would need to see the code, but you most likely need to turn off screen updating, and possibly events until you're done processing.