Home

Sometimes I can't change cell contents

%3CLINGO-SUB%20id%3D%22lingo-sub-679882%22%20slang%3D%22en-US%22%3ESometimes%20I%20can't%20change%20cell%20contents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679882%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I%20am%20using%20Office%20(Excel)%20365.%20Sometimes%20I%20can't%20edit%20the%20cell%20contents.%20When%20I%20click%20on%20the%20cell%20and%20then%20try%20to%20edit%20it%20in%20the%20Formula%20Bar%20it%20won't%20let%20me.%20I%20can't%20even%20get%20focus%20in%20this%20bar.%20Unfortunately%2C%20this%20is%20happening%20often%20enough%20that%20it%20is%20becoming%20annoying.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20some%20searching%20I%20came%20across%20the%20following%20post%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F1104286%2Fintermittantly-cant-edit-excel-cell%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsuperuser.com%2Fquestions%2F1104286%2Fintermittantly-cant-edit-excel-cell%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20user%20is%20having%20exactly%20the%20same%20problem.%20I%20am%20able%20to%20edit%20the%20cell%20by%20following%20the%20indications%20in%20this%20post.%20Is%20this%20really%20a%20problem%20with%20Excel%2C%20or%20do%20I%20need%20to%20do%20something%20to%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%20Saga%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-679882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679909%22%20slang%3D%22en-US%22%3ERe%3A%20Sometimes%20I%20can't%20change%20cell%20contents%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679909%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357305%22%20target%3D%22_blank%22%3E%40SagaV9%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EThis%20is%20really%20a%20weird%20problem!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EI%20have%20not%20encountered%20it%20before!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3EAnyway%2C%20%3CSPAN%20class%3D%22%22%3Ebe%20sure%20of%20the%20following%20to%20overcome%20the%20problem%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMake%20sure%20that%20you%20have%20the%20latest%20Office%20Update%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EMake%20sure%20that%20you%20have%20the%20latest%20OS%20(Windows%2FMac)%20Update%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIf%20you%20have%20some%20add-ins%20installed%2C%20try%20to%20disable%20them%20and%20see%20if%20the%20problem%20is%20gone%20or%20not%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ETry%20to%20repair%20Office%20by%20following%20the%20steps%20in%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Frepair-office-apps-0850af82-da88-4858-9d9a-1b442d933f53%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHope%20that%20helps%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
SagaV9
Occasional Visitor

Hi all, I am using Office (Excel) 365. Sometimes I can't edit the cell contents. When I click on the cell and then try to edit it in the Formula Bar it won't let me. I can't even get focus in this bar. Unfortunately, this is happening often enough that it is becoming annoying. 

 

After some searching I came across the following post:

 

https://superuser.com/questions/1104286/intermittantly-cant-edit-excel-cell

 

This user is having exactly the same problem. I am able to edit the cell by following the indications in this post. Is this really a problem with Excel, or do I need to do something to fix this?

 

Thank you! Saga

1 Reply

@SagaV9

 

Hi,

 

This is really a weird problem!
I have not encountered it before!

 

Anyway, be sure of the following to overcome the problem:

  • Make sure that you have the latest Office Update
  • Make sure that you have the latest OS (Windows/Mac) Update
  • If you have some add-ins installed, try to disable them and see if the problem is gone or not
  • Try to repair Office by following the steps in this link

 

Hope that helps

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies