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

Anonymous
2024-01-25T17:23:24+00:00

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.

Microsoft 365 and Office | Excel | For business | 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 No comments
Answer accepted by question author
Anonymous
2024-02-01T11:11:15+00:00

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

Was this answer helpful?

100+ people found this answer helpful.
0 comments No comments

58 additional answers

Sort by: Oldest
  1. Anonymous
    2024-03-21T07:36:04+00:00

    works great for me too!!! 27-02-2024

    go to excel> file - account - settings management - turn off optional online functions and done

    Thank you, it worked for me.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2024-03-21T20:11:46+00:00

    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

    Thank you very much! This solved my issue! I was adding photo to notes inside the workbook.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2024-03-23T18:26:08+00:00

    Merci beaucoup! Non seulement cela a résolu mon problème, mais Excel s'exécute plus rapidement!

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2024-03-25T18:55:12+00:00

    This also worked for me!

    Thanks Pavol K1

    Was this answer helpful?

    0 comments No comments