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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies