While opening Excel getting error Excel cannot open file .xlsb because the file format or file extension is not valid

Question

While opening Excel getting error Excel cannot open file .xlsb because the file format or file extension is not valid

Bejugam Nagraj 20

While opening the Excel getting error Excel cannot open file xlsb because the file format or file extension is not valid verify that the file has been not corrupted.OfficeIs current channel updated version multiple user facing same issue try to add the trusted location but no luck please suggested if any other.issue is only on specific file web working fine tried another machine but same behaviour

Accepted answer

0 additional answers

Your answer

Answer 1

Jiajing Hua 18,060 Moderator

Hi @Bejugam Nagraj

1 Do you mean Excel application cannot be opened correctly?

If yes, please go to File > Account > Product Information, check the version number.

Then locate to %Appdata%\Microsoft\Excel, C:\Program Files\Microsoft Office\Office16\XLStart (C:\Program Files (x86)\Microsoft Office\Office16\XLStart in case of 64-bit Windows system), remove the .xlsb files. (Please note, you may back them up first before removing.)

2 Or do you mean users cannot open .xlsb files?

If yes, does this issue occur with other Excel file formats, such as ".xlsx"?

I suggest you back up one .xlsb file first, then change the file extension and try to open it.

You may start Excel in Safe Mode, find and open one .xlsb file for a check.

To run Excel in Safe Mode, please press Win + R to open Run dialog,
Enter excel /safe, click "OK".

How do users access the .xlsb file?

It's recommended to move one .xlsb file to other location, please make sure users have enough permission on that folder.

Is there any third-party encryption software to encrypt the .xlsb file?

If so, please unencrypt it for a try.

Besides, please quit the security software if there is.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Bejugam Nagraj 20 Reputation points

2023-12-13T18:41:15.94+00:00

Tried above steps and remove the excel.xlsb as well still same behavior.Please suggest is there any other action plain we tried change the format in .xlsx as well but same behaviour
Jiajing Hua 18,060 Reputation points Moderator

2023-12-14T08:41:07.2633333+00:00

Hi @Bejugam Nagraj

Thanks for your back.

Please also try to disable Protected View.

You may click File > Options > Trust Center > Trust Center Settings > Protected View > Disable three options of Protected View.

As you say it is the specific file on web, you may download it for a check. Please right-click on it, go to Properties, ensure the file is not blocked.
Bejugam Nagraj 20 Reputation points

2023-12-14T11:10:57.0466667+00:00

The file is working some other users and some other user not able to work they tried different office channel with updated version still same behaviour
Bejugam Nagraj 20 Reputation points

2023-12-14T16:37:59.07+00:00

I followed the steps requested on removing the protected view check boxes and results were the same please help me out an other suggestion please
Bejugam Nagraj 20 Reputation points

2023-12-15T09:39:39.2166667+00:00

The file is working some other users and some other user not able to work they tried different office channel with updated version still same behaviour
Jiajing Hua 18,060 Reputation points Moderator

2023-12-18T06:17:47.1366667+00:00
Hi @Bejugam Nagraj

Please compare the Office used by others who can open the file normally, such as the update channel and version number.

If they are using the same Office, it is recommended to check the permission on Windows System.

Right-click the Excel file that cannot be opened and select Properties.

After the file’s Properties dialog opens, select the Security tab, and then click the Edit button.

After the file’s Permissions dialog opens, click the Add button.

When the Select Users or Groups dialog opens, click the Advanced button. When the next dialog opens, click Find Now so all users and groups will show up in the search results list at the bottom of the dialog. Select the Everyone group from the list, and then click OK. Click OK again.

When you return to the Permissions dialog, you will see the Everyone group has been added to the group or user list. Select the Everyone group, check all checkboxes under Allow, and then click Apply.

Share via

While opening Excel getting error Excel cannot open file .xlsb because the file format or file extension is not valid

0 additional answers

Your answer