2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is this an ongoing bug that will never be solved? [Online excel spreadsheets: comments overwrite cell]

Hi everyone,

This is seriously bugging me and my team and I thought maybe I figured out the cause but it seems I was wrong.

The issue: Our team uses various online excel based spreadsheets connected through sharepoint.

When we select a cell and right click to add a new comment (or use ctrl+alt+m) the comment text box appears.

Everytime we begin typing, instead of adding our text to the comment text box it begins writing in the cell that was selected for the comment and overwrites whatever is written.

We thought the first work around was to ensure you click, multiple times, into the comment text box to ensure your cursor is placed correctly. This sometimes gives you the impression that is the cause but no, I've had it happen multiple times after clicking furiously into the text box.

Then at one point I noticed it happened less when you waited some time after right click and selecting add new comment. I figured eureka! the issue was that this is an online sheet and it is "loading" and thus there is a lag and if you wait, it will catch up and do the right thing.

Welp no that isn't either. I've been waiting patiently after starting a comment but I'll begin typing after waiting 10-15 seconds and it still overwrites the cell selected.

This is pretty egregious and an obvious bug....it's been going on for almost a year now....

Is it just my team lol or is this a known excel bug ?

submitted by /u/CndConnection
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#generative AI for data analysis
#big data management in spreadsheets
#AI-native spreadsheets
#rows.com
#financial modeling with spreadsheets
#predictive analytics in spreadsheets
#cloud-based spreadsheet applications
#real-time data collaboration
#excel
#bug
#spreadsheet
#cell
#comments
#comment text box
#sharepoint
#overwrite
#cursor