'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Set the Default Edit Data Window Size in Excel from PowerPoint
Question details
The user wants to configure the default size and position of the temporary Excel window that opens when selecting 'Edit Data' for a chart in PowerPoint.
- Product
- Microsoft PowerPoint
- Device & OS
- not provided
- Scenario
- Editing chart data linked between PowerPoint and Excel.
- Observed behavior
- The temporary Excel data editing window opens at a size that may exceed the screen boundaries, and standard Excel window settings do not apply to it.
Ensure your Microsoft Office application is updated to the latest version, as display bugs affecting temporary windows are sometimes patched in newer releases.
Manually Resize the Window and Submit Feedback
Currently, PowerPoint does not offer a native setting to control the default size of this temporary Excel window. The best approach is to resize it manually and report the issue to the product team.
Standard Excel window size configurations do not apply to the temporary workbook launched by PowerPoint's 'Edit Data' feature. Because this is a known limitation affecting multiple versions (including version 2212), the Microsoft product team relies on user feedback to prioritize a fix.
When the oversized Excel window opens, hover your cursor over the edge or corner until it turns into a double-headed arrow, then click and drag to resize it to fit your screen.
In PowerPoint, click on the 'Help' tab in the top ribbon and select 'Feedback', or go to 'File' > 'Feedback'.
Choose 'Report a Problem' or 'I have a suggestion'. Describe the oversized 'Edit Data' window issue, including your screen resolution, OS version, and PowerPoint version.
Use the Full 'Edit Data in Excel' Option
If the temporary pop-up window is too buggy, opening the data directly in the full Excel application might bypass the sizing issue.
Experience Seamless Chart Editing with WPS Presentation
Tired of encountering window sizing bugs when editing chart data in Microsoft PowerPoint? Switch to WPS Office. Enjoy a unified, lightweight presentation software with seamless built-in chart editing, fully compatible with Microsoft Office formats.
Frequently Asked Questions
Why does the Excel Edit Data window open larger than my screen in PowerPoint?
This is a known interface quirk in Microsoft Office. The temporary Excel workbook used for PowerPoint chart data does not inherit your standard Excel application window settings, causing it to occasionally default to dimensions larger than your current screen resolution.
Can I permanently save the position of the temporary Excel window?
No, Microsoft PowerPoint currently does not provide a built-in feature to save or remember the default size and position of the temporary chart editing window. You must manually resize it during each session.
Where can I find the Feedback option in PowerPoint to report this issue?
You can find it by navigating to the 'File' menu and clicking on 'Feedback' at the bottom left panel, or by clicking the 'Help' tab on the top ribbon and selecting the 'Feedback' icon.
