![]() When you're running a system with multiple resolutions, OLE doesn't know which resolution to use. This is why you'll find a bazillion questions along the lines of "I changed my monitor and now I see a different number of columns in an embedded Excel sheet". Is there any way of resizing the range without resorting to adjusting display scaling everytime?Įditing embedded or linked content relies on OLE. However, there is no apparent way of resizing the range to be displayed. Double clicking the object opens Excel to edit the data. There is no way to resize the range to show more rows/columns. Inserting an Excel table shows only 4 cells: Deselecting and then double clicking the object shows the same resizing function.īehaviour if any screen scale is set above 100%, eg, laptop is set to 125% (Recommended) The mini Excel view shows resizing handles allowing resizing to the required number of rows/columns. In Word/PowerPoint choose Insert > Table > Excel Spreadsheet orĬopy a range from an existing Excel worksheet and Paste Special as Microsoft Excel Worksheet Object I've also tested this on 4k displays where the scaling is set to 200% (Recommended) value and can reproduce the issue. I'm using a laptop connected to multiple displays with the laptop display scaling set to 125% (Recommended). This affects multiple builds of MS Office in our environment, but the one on my system is version: 1902 (Build 11328.20158 Click-to-Run) How to swap embedded excel to powerpoint 2016 mac windows#The issue seems to be related to Windows display display scaling if any display scale is set above 100%, eg, laptop display scaled to 125% (Recommended) or higher. Double clicking to activate the sizing controls for the embedded sheet instead opens Excel to edit the data with no way of increasing the range area to be displayed. ![]() ![]() We've come across an isssue were an Excel embedded table in PowerPoint or Word cannot be resized.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |