Blog Post

Excel Blog
1 MIN READ

Re: Get & Transform (Power Query) in Excel for Mac - Phase 1

jhester's avatar
jhester
Copper Contributor
Sep 09, 2020

odhanson, Glad to hear that refreshing from table/range should now be available. I've tried making a query to combine data from a couple of tables into one table on my PC (Excel 365 version 2007, build 13029.20344) and shared with a colleague who uses a Mac (Version 16.40, 20081000), and though they did not encounter any error messages, when he tried to refresh the table it got stuck on refreshing and wouldn't finish after a minute or two (it only takes 5 seconds or less on my computer). It appears that the file thinks there are external data connections because Excel prompted my colleague to enable external data connections, but I only connected it to tables within the file. I'm guessing queries might be considered an external data connection, even if connected to the same file? 

Published Sep 09, 2020
Version 1.0
No CommentsBe the first to comment