Forum Discussion
Excel 2016 - Power Query Error: "Cannot Refresh Data Type" but data refreshes
Suddenly one day last week when I refresh my Excel 2016 Power Query file I receive the error "Cannot refresh data type." However, I click OK and data still refreshes but I do not understand how to f...
Woopakay72This is odd but I received the same message this morning on one that was working perfectly with multiple queries. All I had to do was go on the internet. I found that when i am not online i get this error, as soon as I am online and have an internet connection to my pc the error went away. I have no idea why, it is a local file, but the message went away.
That is odd. I am working remotely and connected to Internet. Doesn't make a difference. I have not yet gone into the office to run it to see if the error goes away. My back-up with copies of the file, receives the same message--he is also working remotely. Does seem strange that one day all works as it has for nearly 4 years, then all of sudden doesn't.