Cell be locked after copy paste on web base excel online

%3CLINGO-SUB%20id%3D%22lingo-sub-916408%22%20slang%3D%22en-US%22%3ECell%20be%20locked%20after%20copy%20paste%20on%20web%20base%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-916408%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20got%20an%20issue.%20When%20we%20copy%20and%20paste%20on%20excel%20online%20web%20base%20(chrome%2Ffirefox)%2C%20the%20cell%20on%20that%20file%20will%20automatically%20be%20locked.%20This%20all%20happens%20to%20all%20files.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20working%20with%20my%20group%20by%20share%20excel%20files.%20To%20protect%20the%20files%20I'm%20the%20only%20one%20who%20can%20do%20it%20by%20open%20the%20excel%20desktop%20version%20on%20my%20MacBook%20and%20protect%20the%20sheet.%3C%2FP%3E%3CP%3EEvery%20day%20I%20protect%20the%20file%20if%20the%20cell%20is%20filled%20if%20the%20cell%20hasn't%20be%20filled%20will%20not%20lock.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuddenly%20right%20now%2C%20all%20my%20team%20reported%20that%20the%20files%20automatically%20lock%2C%20can't%20be%20edited%20after%20they%20copy-paste%20into%20a%20cell%20without%20I%20lock%20the%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20someone%20here%20have%20the%20same%20experience%20and%20how%20to%20deal%20with%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESincerely%3C%2FP%3E%3CP%3EK%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-916408%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-948269%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20be%20locked%20after%20copy%20paste%20on%20web%20base%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-948269%22%20slang%3D%22en-US%22%3E%3CP%3EI%20noticed%20the%20same.%20%26nbsp%3BCouldn't%20figure%20out%20for%20months%20why%20cells%20would%20be%20locked%20and%20then%20finally%20realized%20it%20yesterday.%20%26nbsp%3BCopy%2Fpaste%20from%20any%20other%20document%20into%20Excel%20online%20will%20lock%20the%20cell.%20%26nbsp%3BIt%20wasn't%20happening%203-4%20months%20ago%20but%20certainly%20happens%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F427009%22%20target%3D%22_blank%22%3E%40report666%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-956356%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20be%20locked%20after%20copy%20paste%20on%20web%20base%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-956356%22%20slang%3D%22en-US%22%3E%3CP%3EBounce%20it%20up!%20so%20the%20team%20from%20microsoft%20will%20see%20and%20do%20something.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F427009%22%20target%3D%22_blank%22%3E%40report666%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-969024%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20be%20locked%20after%20copy%20paste%20on%20web%20base%20excel%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-969024%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20issue%20getting%20worse%2C%20This%20not%20only%20happening%20on%20excel%20online%20web%20base.%20We%20also%20had%20this%20bad%20experience%20in%20excel%20365%20%26nbsp%3Beither%20desktop%20version%20on%20Mac%20or%20Windows%20version.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cells%20in%20a%20file%20should%20be%20locked%20by%20me%20as%20an%20owner%20or%20admin%20of%20the%20file%20by%20opening%20the%20protect%20sheet%20then%20go%20to%20format%20cells%20tick%20the%20lock%20feature%20then%20protect%20back%20the%20sheet%20with%20the%20same%20password.%3C%2FP%3E%3CP%3EBut%20right%20now%20the%20cell%20in%20an%20Excel%20file%20will%20automatically%20be%20locked%20after%20pasting%20from%20another%20source%20without%20doing%20such%20as%20mentioned%20above.%20After%20the%20cell%20is%20locked%2C%20the%20cell%20showed%20a%20blank%20white%20cell.%3C%2FP%3E%3CP%3EIf%20I%20unlock%20the%20cell%2C%20the%20cell's%20format%20change.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20issue%20makes%20us%20stressfully.%20I%20should%20unlock%20and%20lock%20every%20error%20cells.%3C%2FP%3E%3CP%3EIs%20there%20anyone%20from%20Microsoft%20here%20to%20help%20solve%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBounce%20it%20up!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F427009%22%20target%3D%22_blank%22%3E%40report666%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I've got an issue. When we copy and paste on excel online web base (chrome/firefox), the cell on that file will automatically be locked. This all happens to all files. 

 

I was working with my group by share excel files. To protect the files I'm the only one who can do it by open the excel desktop version on my MacBook and protect the sheet.

Every day I protect the file if the cell is filled if the cell hasn't be filled will not lock.

 

Suddenly right now, all my team reported that the files automatically lock, can't be edited after they copy-paste into a cell without I lock the sheet.

 

Does someone here have the same experience and how to deal with this?

 

 

Sincerely

K

3 Replies

I noticed the same.  Couldn't figure out for months why cells would be locked and then finally realized it yesterday.  Copy/paste from any other document into Excel online will lock the cell.  It wasn't happening 3-4 months ago but certainly happens now.

 

@report666 

Bounce it up! so the team from microsoft will see and do something.


@report666 

The issue getting worse, This not only happening on excel online web base. We also had this bad experience in excel 365  either desktop version on Mac or Windows version.

 

The cells in a file should be locked by me as an owner or admin of the file by opening the protect sheet then go to format cells tick the lock feature then protect back the sheet with the same password.

But right now the cell in an Excel file will automatically be locked after pasting from another source without doing such as mentioned above. After the cell is locked, the cell showed a blank white cell.

If I unlock the cell, the cell's format change.

 

This issue makes us stressfully. I should unlock and lock every error cells.

Is there anyone from Microsoft here to help solve this issue?

 

Bounce it up!

 

@report666