Is this an ongoing bug that will never be solved? [Online excel spreadsheets: comments overwrite cell]
Our take
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 ?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Formulas are "sticking" in the cell, not calculating when enteredWhen I input simple formulas into cells, and hit enter, they are not calculating. When I hit enter, the full formula remains viewable in the cell, all other functions work properly, I can continue inputting and working with the spreadsheet, its not frozen per se. Is this a bug? The only way I have found to work around this is to copy and paste formulas from other cells, but that doesn't work every time either. I am using Windows 11 on a Thinkpad Microsoft® Excel® for Microsoft 365 MSO (Version 2602 Build 16.0.19725.20078) 64-bit - using both the online and the app version of excel. https://preview.redd.it/kkz4xu00jhmg1.png?width=207&format=png&auto=webp&s=3a0632fcf96e8f891258a437e9e41349dc180036 submitted by /u/Top_Floor6422 [link] [comments]
- NEED ADVICE re serious issues on collaborative company workbook. Appealing to Reddit's Excel wizards as a last resort.I work as part of a small team sharing an Excel workbook with my associates. The document is integral to company operations and requires continuous updating on multiple fronts. It is very large (7MB) and extremely complex, with about a dozen sheets using complex, interrelated formulas. There are up to four people on the document at any one time, with two of them making constant edits and using heavy filters throughout the day and the other two primarily just filtering for key items to inform business decisions. All four usually operate from different locations, sometimes across the country. We recently expanded the operations team from one to two people, since which time the document has been experiencing significant issues—none of which occurred prior to the new associate joining. These issues appear to stem from the new situation of having two people editing simultaneously for the first time, and include: Merging problems Regular crashes Filtering issues, such as when we are both filtered within the document and one person uses control+D to fill down in a filtered column, other rows that the one person’s filters do NOT show in that moment have been filled in as well. The workbook is stored on OneDrive but accessed and edited through the desktop Excel application with AutoSave enabled. Surely we are not the first business to face this issue. Are there any solutions we may be overlooking? How have other businesses approached such matters? It is imperative that the workbook remain updated in real-time for all involved for business purposes. Finally, please let me know if any other subreddits or communities (perhaps discord?) come to mind where I may find answers to the above. submitted by /u/LingeringOdor [link] [comments]
- Excel buffering while working between 2 workbooksHi everyone, Since the second last Office update, working in split screen with multiple excels has become very tiresome. When working between 2+ workbooks, my excel suddenly needs a few seconds to "load" the excel book before I can start interacting with it. Since the same update, it is almost impossible to work in a shared excel because everytime an edit is made by a different user, it has to restart to reflect the changes. While I can probably learn to live with these issues, I would prefer not to. It is quite frustrating. I have tried looking for this issue only but haven't had any luck. I would really appreciate it if anyone has any insight on how to fix these problems. Thanks! Edit: my excel version is Microsoft Excel for Microsoft 365 MSO (Version 2603 Build 16.0.19822.20086) 64-bit submitted by /u/Emotional-Revenue309 [link] [comments]