Excel online- Unable to paste data in cells containing formula

[rajbhaskar221]

Hi,

I am facing issue in updating text in a cell containing formula.
Formula used is
=IF(B2<>"","Enter user E-Mail ID here","")

As intended, when B2 is not blank the Cell C2 will display text "Enter user E-Mail ID here". If I paste Email ID from outside workbook in C2, the email ID gets displayed for few seconds and then get reverted back to the display text "Enter user E-Mail ID here".
•Issue is being faced only when we are pasting email ID or web urls. Even on manually typing Email Ids, same issue is being faced.
•Issue is only with cells containing formula. With blank cells, this is working fine.
Until last week, this was working fine and I am clueless what could have caused this issue.
Observations-
•only the hyperlink is getting created by ctrl+v, the display text or cell content remains the formula generated text.
•if I perform ctrl+v twice the display text is getting updated, however the change is not getting saved. If I refresh / reopen the online workbook, the display text is getting reset to formula based output.
•the paste is working fine if edit is performed through "edit in excel" option so issue is only when we are using "Edit in Browser" option.
•This is replicable on multiple excel online files and on different systems so this cant be a local issue.

System details -
Microsoft OneDrive Version 2018 (Build 17.3.7294.0108)
Office 2016.

Please let me know if there is any such known issue and what could be the workaround or possible fix.

Regards,
Bhaskar Raj

 

[Joe4]

Welcome to the Board!

It sounds to me like you might possibly have some Event Procedure VBA code at play here.
If so, can you paste the VBA code from that particular sheet module so we can see what it looks like?

 

[rajbhaskar221]

Welcome to the Board!

It sounds to me like you might possibly have some Event Procedure VBA code at play here.
If so, can you paste the VBA code from that particular sheet module so we can see what it looks like?

Hi Joe,
This is .xlsx file uploaded on onedrive and we are facing this issue while using "edit in browser" feature of Excel online (web app).

Regards

 

[Joe4]

This is .xlsx file uploaded on onedrive and we are facing this issue while using "edit in browser" feature of Excel online (web app).

OK. So that rules out VBA.
Definitely sounds like it is tied to the "edit in browser" feature in the Web App (which I have never used).
It also sounds like you cannot make any changes to it (i.e. it is "Read Only). Are you able to make other changes and save them?

 

[rajbhaskar221]

The file is editable and I am able to enter data other than email IDs or Url in the formula cells overwriting the formula. The issue kicks in only when I am trying to paste email ID/ url.
This issue is not occurring if I open the file in local (using "edit in excel") feature of excel online.

 

[Fluff]

Whilst I've never used Excel Online before, I've just tried doing what you're doing & am getting the same result.
So, I suspect it has something to do with the online version, but unfortunately I've no idea what or why

 

[rajbhaskar221]

Whilst I've never used Excel Online before, I've just tried doing what you're doing & am getting the same result.
So, I suspect it has something to do with the online version, but unfortunately I've no idea what or why

Thanks for taking out time and validating it.
It was working fine till last week. I am unable to trace any change done from user end or OneDrive updates either, so raised this on forum to check if it is a known issue.