'%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)
Fix Excel Bad Request Error When Adding Pictures to Notes
Question details
The user needs a solution to bypass a request size error that prevents adding pictures to cell notes.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Adding a picture to a cell note using the Format Comment and Fill Effects options.
- Observed behavior
- Excel displays a Bad Request or HTTP 400 error stating that the request headers are too long. The issue persists across different worksheets and remains even after restarting the application.
Save your current workbook locally to ensure you do not lose any progress before modifying Excel's account privacy and connected experience settings.
Disable Optional Connected Experiences
Turning off optional connected experiences prevents Excel from attempting online synchronizations that trigger the HTTP 400 request-size error.
This error is often caused by a bug in a recent update related to Microsoft Office's connected services. When Excel tries to process the picture insertion through its online services, the request header exceeds the size limit, throwing the Bad Request error. Disabling these optional experiences forces Excel to handle the action locally.
Launch Microsoft Excel and click on 'File' in the top-left corner of the ribbon, then select 'Account' from the left-hand sidebar.
Under the Account Privacy section, click on the 'Manage Settings' button to open the privacy configuration window.
Scroll down to the 'Optional connected experiences' section. Clear the checkbox that says 'Turn on optional connected experiences'.
Click 'OK' to save your changes, then completely close and restart Excel for the settings to take effect.
Use WPS Office to Add Pictures to Spreadsheets Seamlessly
Since this Bad Request error is tied to a specific Microsoft Excel update and its connected services, switching to WPS Office provides an immediate fix. WPS Office is a free, lightweight alternative offering high compatibility with Excel files and a familiar interface, entirely bypassing these online sync bugs.
- 1. Download and Install: Download WPS Office Free from the official website and follow the lightweight installation process.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .xls file directly without any format conversion.
- 3. Insert Pictures Easily: Right-click your desired cell to insert a comment or note, and seamlessly add your picture without encountering header size limits.
Frequently Asked Questions
Why does Excel say request headers are too long when adding a picture?
This HTTP 400 Bad Request error is typically caused by a bug in Excel's optional connected experiences. When you insert an image, Excel attempts to sync the data through an online service, but the data size exceeds the server's allowed request header limit.
Will disabling connected experiences affect other Excel features?
Yes. Disabling optional connected experiences will turn off certain online-dependent features, such as downloading premium online templates, inserting online pictures, or using specific web add-ins. You can always re-enable the setting later from File > Account > Manage Settings.
Does this HTTP 400 error affect all worksheets in my workbook?
Yes, users consistently report that once this Bad Request error is triggered, it persists across all worksheets within the workbook and continues to appear even after restarting the Excel application, until the connected experiences setting is turned off.
