An excel workbook accessed via Teams will not allow formatting.

Question

An excel workbook accessed via Teams will not allow formatting.

Anonymous

We currently have a few workbooks being accessed by the team via Teams.
Earlier this week, users haven't been able to format the cells.

Yes, there is worksheet protection, however it has the following options Allowed:

Select Locked Cells
Select Unlocked Cells
Format Cells
Format Column
Format Rows
Use AutoFilter
Edit Objects
Edit Scenarios

Accessing the same workbook via Teams Online is still not allowing formatting. Opening the Workbook in the Desktop App will allow formatting. Yes I know that's a workaround, however this feature has been working fine until this week?

I've just checked the Service Health, and none of the Active Issues relate to this.

Any suggestions?

Sijia You 0 Reputation points

2023-05-05T09:12:24.86+00:00
B

h1

hhhhh\

baidu
SokiGuo-MSFT 31,536 Reputation points Microsoft External Staff

2023-05-08T02:14:57.4166667+00:00

Hi @Anonymous

Thanks for visiting our forum. Microsoft Teams tag is mainly focused on the general issue of Microsoft Teams application troubleshooting. According to your description, I have the following questions to confirm with you:

Do other users in your organization have the same problem?

Is this a file sent by a personal chat or a channel file?

Is this file set with permissions?
Anonymous

2023-05-08T04:52:38.07+00:00

Hi @SokiGuo-MSFT , I had a lot of issues trying to get this post in the first place >.< ended up with 3 copies somehow.
Anywho.

Yes, all users I've asked are having this issue.
They're able to open in the Desktop App and format just fine, it's just that workbook in Teams.

It's a channel file.

The permissions that the team have is edit. The workbook itself has locked sheets, but the formatting is allowed.
The moment we take the permissions off, you can format. This is the Manage Protection Snip.

The reason this was placed in Microsoft Teams, is because we don't have issues formatting in the Excel Desktop App, just the Microsoft Teams desktop and web app.
SokiGuo-MSFT 31,536 Reputation points Microsoft External Staff

2023-05-10T05:38:56.84+00:00

Hi

Did you set these settings elsewhere?

Based on my tests, access to and editing of files can only be set in Teams.
SokiGuo-MSFT 31,536 Reputation points Microsoft External Staff

2023-05-12T09:23:54.94+00:00

Hi

Haven't received your message for a long time.

I look forward to your kind response.

1 answer

Your answer

Sijia You 0 Reputation points

2023-05-05T09:12:24.86+00:00

B

h1

hhhhh\

baidu
SokiGuo-MSFT 31,536 Reputation points Microsoft External Staff

2023-05-08T02:14:57.4166667+00:00

Hi @Anonymous

Thanks for visiting our forum. Microsoft Teams tag is mainly focused on the general issue of Microsoft Teams application troubleshooting. According to your description, I have the following questions to confirm with you:

Do other users in your organization have the same problem?

Is this a file sent by a personal chat or a channel file?

Is this file set with permissions?
Anonymous

2023-05-08T04:52:38.07+00:00

Hi @SokiGuo-MSFT , I had a lot of issues trying to get this post in the first place >.< ended up with 3 copies somehow.
Anywho.

Yes, all users I've asked are having this issue.
They're able to open in the Desktop App and format just fine, it's just that workbook in Teams.

It's a channel file.

The permissions that the team have is edit. The workbook itself has locked sheets, but the formatting is allowed.
The moment we take the permissions off, you can format. This is the Manage Protection Snip.

The reason this was placed in Microsoft Teams, is because we don't have issues formatting in the Excel Desktop App, just the Microsoft Teams desktop and web app.
SokiGuo-MSFT 31,536 Reputation points Microsoft External Staff

2023-05-10T05:38:56.84+00:00

Hi

Did you set these settings elsewhere?

Based on my tests, access to and editing of files can only be set in Teams.
SokiGuo-MSFT 31,536 Reputation points Microsoft External Staff

2023-05-12T09:23:54.94+00:00

Hi

Haven't received your message for a long time.

I look forward to your kind response.

Answer 1

Hi,

It's possible that there may have been an update or change to the Teams or Excel online platform that is causing this issue. Here are a few suggestions from my side-

Check if there are any updates available for Excel online or Teams. Updating to the latest version may resolve the issue.
It's possible that there may have been a change to the settings accidentally or by another user. Maybe try checking once.

Try opening the workbook in a different web browser or clearing the cache and cookies in the current browser. Sometimes, browser issues can affect how Excel online works.

Make sure that the users who are trying to format the cells have the necessary permissions. If they have been recently added to the team or their permissions have been changed, it's possible that they may not have the necessary access to format the cells.

Best Regards.

Share via

An excel workbook accessed via Teams will not allow formatting.

1 answer

Your answer