I am making a workbook that has a table on one sheet for reviewing worker trainig data. I am now making a sheet to graphically show particular workers in a chart.
To achieve the type of filtered table needed for the chart this code is using Advanced Filtering to take some columns and start building them on a separate sheet. There I will continue to process more things needed for the chart to work, but the RefreshChartData is causing some weird buildup that makes the sheet need repair that is always fixed with "Removed records: Protection" for the sheet where the data is getting copied to. It seems to break after using the macro abour 4 times. I tried taking out the ClearClipboard, but it still breaks. I tested clicking at a much slower frequency and even saved in between each click, reopened, and repeat until around the 4th time it needs repair on opening.
Any help is greatly appreciated
Bookmarks