Forum Discussion
Old data not clearing when refreshing
Hi team, I am a an experienced intermediate Excel user but a Power Query novice. I have a reference workbook with a list of Active Employees for each month in a separate tab. Around 23k rows ...
Hi Stephen et al,
Thank you for your original reply. I am getting the hang of providing enough information. To reiterate, I was mistaken about not clearing the final rows of the previous data.
It appears that PQ is working correctly referencing the new tab and showing in the summary the correct number of rows but there is no change to the data. It is stil showing all the Sep tab data and not the new Oct tab data.
Thanks for your help
Graeme