Fix an Excel Image in OneNote That Stops Refreshing When Rows Are Hidden
Question details
The user needs an Excel worksheet image in OneNote to reflect changes reliably when rows or columns are hidden.

- Product
- Microsoft Excel and Microsoft OneNote
- Device & OS
- Windows 10 (tested on another computer)
- Scenario
- An Excel worksheet is embedded in a OneNote page for display and updates.
- Observed behavior
- The worksheet image may stop refreshing after rows or columns are hidden. Unhiding them can restore updates, but the issue is intermittent.
Check whether the OneNote page contains an editable Excel spreadsheet or a static file printout or image. A static image or printout will not automatically reflect later workbook changes.
Test the OneNote worksheet display with all rows and columns visible
Use this test to check whether hidden rows or columns are associated with the stalled display.
In OneNote, open the page containing the spreadsheet and use its Edit option to open it in Excel.
In Excel, select the entire worksheet using the button at the intersection of the row and column headings. Go to Home > Format > Hide & Unhide, then choose Unhide Rows and Unhide Columns.
Save the workbook in Excel, return to the OneNote page, and check whether the worksheet display reflects your changes.
In Excel, hide a row or column, make a visible change, and save. Return to OneNote to see whether the display updates. If it stops updating, unhide the row or column and check again.

Restart the apps and compare a new Excel workbook
Use a new workbook and a restart to help determine whether the behavior is specific to one worksheet or intermittent.
Edit Excel Workbooks with WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets. Its Microsoft Excel format compatibility makes it easy to move existing workbooks into WPS, although it does not fix OneNote's embedded-image refresh behavior.

Frequently Asked Questions
Why doesn't my Excel printout in OneNote update automatically?
A file printout or pasted image is a static representation of the workbook. To show later changes, insert an updated printout or image rather than expecting the existing one to refresh.
How do I unhide all rows and columns in Excel?
Select the worksheet using the button where the row and column headings meet. Then go to Home > Format > Hide & Unhide and select Unhide Rows and Unhide Columns.
Could Excel calculation settings affect the display?
Calculation settings can affect whether formula results are current in the workbook. In Excel, check File > Options > Formulas and select Automatic under Workbook Calculation if appropriate. This may not fix a OneNote display refresh issue.
What should I do if the issue returns?
Test the display with all rows and columns visible, restart OneNote and Excel, and compare a new workbook. If the problem persists, contact Microsoft Support with the results of those tests.




