70 votes11 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Table structured references are a more well-defined way to model information.
It is very natural that dynamic arrays should be able to be used in tables and expand and contract the number of rows.
Tables are also an invaluable asset to work with automation with Microsoft Flow, it should be possible to combine dynamic arrays with them and leverage the result in Microsoft Flow automation.
We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.
Refer to the following blog post for more details:
I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.
94 votes94 comments · Excel for Windows (Desktop Application) » Performance · Flag idea as inappropriate… · Admin →
Thanks for opening this item and the feedback folks! Please provide more info on the type of Display monitors that you experience this issue with. Also continue voting on this which will increase its likelihood of getting prioritized for fixing in the product.
This problem is very frequent when using MS Office alongside Intel integrated GPUs. For whatever reason, I don't see it manifest on Nvidia/ATI cards.
That said, this is not sufficient to just brush off the problem to the other side of the fence. Countless apps (and games) work just fine with Intel GPUs. it could be a side effect of shared memory between cpu and gpu, or countless other reaons.
Both vendors need to work together to find out a common cause.
Having Windows u-to-date, with the most recent Intel GPU drivers does not alleviate the issue.
Example machines where I found this problem:
Lenovo Yoga 2
Lenovo Yoga 500
Lenovo Yoga 900
Apple MacBook Pro Retina Display 2013 (on Boot Camp)
MacBook Air 2013(on Boot Camp)
I have seen many complaints from other users of machines from other vendors, like dell, hp, acer, asus... It's not limited to vendor customizations for drivers, it seems.
It usually happens with high resolution displays, full HD or higher.
It also happens even with Windows 1607 64 bits, updates to the fullest, and video drivers updated as well.
Disabling hardware acceleretion does not solve it.
Running OfficeCAT does not solve it.
There is something which could be a buffer overrun when excel is using a large portion of a high resolution screen - try a setup with multiple UHD monitors to try to reproduce.
47 votes4 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →