1 of 1 people found this helpful
Apply user filter to empty sheet and copy that sheet and paste in in the target workbook ,
You will get a filter from the production workbook since both are same --> apply that filter to relative data source --> delete the copied work sheet --> close the copied connection
you will get the same user filter which was in Production
Hope this helps,
Kindly mark this answer as correct or helpful so that it will help others
Thank you! This saved me tons of time and effort. I used to have the ability to simply Copy and Paste but it's good to know this method works.
Glad it helped kindly mark the answer as correct to close this thread
Doesn't allow me to. Seems only the person who posted can mark as "Correct".