Our Master File is (File_A)Contains Macros. Users Clicking Submit button na Copy paste the that users login data to ( File_B).Here everything is perfect
So duplicating (File_B) data into (File_C) Using Power Query. (File_C) is only for Team Lead Reference somtimes time only they open. No one touch the (File_B).
Now(File_C) Is Open PQ will collecting data from (File_B) perfectly done. But that time Users Clicking Submit Button in File_A na macro run perfectly bt macro unable to save (File_B). I got this errors
Someone else is working in file_a right now. Please try again later
Plse help this error (or ) Whithout PQ any idea about depulicating File B workbook bt datas need to automatically updatethanks for advance
