May I ask what is the problem with my power queries are not available to update when I update my data in tables? Even I have save it and refresh the data. Is it will be affected after I add the VBA Macro Button?
Attach a sample workbook
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.