none
Power Query error - Unable to get the NumberFormat property of the Range class RRS feed

  • Question

  • I can't find any search results on this error:

    Unable to get the NumberFormat property of the Range class

    There are tons of search results about this Excel error:

    Unable to set the NumberFormat property of the Range class

    Here is error screenshot.


    I am getting this error when refreshing Power Query using VBA, but not when refreshing query directly:

    ThisWorkbook.Worksheets("mySheet").Range("myQueryRange").ListObject.QueryTable.Refresh 

    Any ideas on what is happening?

    Wednesday, April 27, 2016 5:48 AM

Answers