Excel HTTP Error 400. The size of the request headers is too long

Anonymous

Good afternoon,

Today I was helping a user, Alice, change a picture in the header of an excel workbook. When Alice clicks the "picture" button in the ribbon under the "Header and footer" tab, instead of showing the dialog to pick a file to insert, the window that pops up says "HTTP Error 400. The size of the request headers is too long" with no other information.

Notably, if Bob, another user with an apparently identical account and user profile, tries to follow the same steps on the same computer as Alice, Bob is able to do so without receiving the error message.

We have tried the following:

Reinstall office365

Sign out of user account and back in

Split the document into smaller documents in case it was a file size issue

Running the repair tool for office365

Thank you!

Edit:

Good morning! I am happy to say we found a solution! Unfortunately it was to reinstall Windows.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Good afternoon,

Today I was helping a user, Alice, change a picture in the header of an excel workbook. When Alice clicks the "picture" button in the ribbon under the "Header and footer" tab, instead of showing the dialog to pick a file to insert, the window that pops up says "HTTP Error 400. The size of the request headers is too long" with no other information.

Notably, if Bob, another user with an apparently identical account and user profile, tries to follow the same steps on the same computer as Alice, Bob is able to do so without receiving the error message.

We have tried the following:

Reinstall office365

Sign out of user account and back in

Split the document into smaller documents in case it was a file size issue

Running the repair tool for office365

Thank you!

the following solution is also possible:

file - account - settings management - turn off optional online functions and done

0 comments

58 additional answers

Anonymous

2024-04-30T12:37:05+00:00

Anyone know if Microsoft plans to fix this? It's been almost 4 months. My users are not happy about having to jump through hoops every time they want to add the company logo (from a local file) to a header/footer. Used to work fine until an update was pushed out. The behavior is also very inconsistent. You can uncheck that optional connected experiences but it doesn't always fix the problem. In one case, I had to recheck the box, restart excel, enter some text into the footer then try to insert the picture and it worked, with the box checked. Then a few days later, it stopped working again. This time, I had to leave the box unchecked. Very confusing & frustrating for the users.
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments
Anonymous

2024-05-08T23:22:16+00:00

Same! Our employees struggle with this; We have to insert company logo for every report and it's such a headache to do all of that for each report. it also doesn't always work. We need a permanent solution.
Was this answer helpful?

0 comments No comments
Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more
Anonymous

2024-05-14T13:43:07+00:00

Hi,

I'm not sure if you're still experiencing the issue, but flushing the DNS solved it for me!

1 Close all your Office-related apps.

2 Press Windows + R and type "cmd" (or open a command shell).

3 Type "ipconfig /flushdns" and press Enter. You'll see a message confirming that the DNS cache has been flushed.

4 Open Excel.

Hope this helps!
Was this answer helpful?

0 comments No comments