Query error from table using Excel 2016

Question

Im trying to run a query "from table" on my Excel 2016 but error prompts. It says Expression.Error: We couldn't find an excel named "Sheetname'!_FilterDatabase'.

Details:

      "Sheetname'!_FilterDatabase'.

The process I did is Open my excel file >> select the Sheet >> select a cell >>> on the Data tab >> select "From table"

As part of my troubleshooting I tried to run the same query using MS Excel 2010 power query on the same file and no error encountered.

I also tried to research online and saw the link below: 

https://social.technet.microsoft.com/Forums/en-US/cfd5dab1-cb14-45b9-98f9-9b8865ce6d4c/sheetnamefilterdatabase-method-in-excel-2016?forum=powerquery

Please help.

Thanks,

Sam

***Post moved by moderator to the appropriate category***

Answer 1

Hi Guys,

Did you find anything on how to resolve the issue: Expression.Error: We couldn't find an excel named "Sheetname'!_FilterDatabase'.

By the way, It says that ******Post moved by moderator to the appropriate category***.*What does it means? Is the original post being moved? if yes, where i can find it then?

Thanks,

Sam