Forum Discussion

campelliann's avatar
campelliann
Icon for Post Patron rankPost Patron
6 years ago
Solved

xlnm filter duplicate "error" when refreshing data

Hi,   I am uploading several excel workbooks from a single folder. Each workbook has a worksheet for each person with his/her name.  I am getting this error xlnm filterdatabase, it seems this does...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    campelliann 
    Did you figure out which specific excel file caused that error, just test out. 

     

    Once you have find the problematic excel, copy all the cells and paste them in an empty new sheet then work with the new sheet, remove the old one.

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

campelliann 
Did you figure out which specific excel file caused that error, just test out. 

 

Once you have find the problematic excel, copy all the cells and paste them in an empty new sheet then work with the new sheet, remove the old one.

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.