Excel Online field comments not displaying

%3CLINGO-SUB%20id%3D%22lingo-sub-2525096%22%20slang%3D%22en-US%22%3EExcel%20Online%20field%20comments%20not%20displaying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2525096%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20we%20use%20O365%20(E3%20license)%20and%20use%20many%20shared%20Excel%20spreadsheets.%20One%20such%20sheet%20that%20we%20open%20mostly%20with%20web%2FExcel%20Online%20recently%20stopped%20displaying%20the%20field%20comments%20in%20the%20normal%20Pop-up%20display%20or%20in%20the%20Comments%20pane%20on%20the%20right-hand%20side%20when%20opened.%20We%20can%20open%20the%20file%20in%20desktop%20Excel%20and%20still%20see%20them%20so%20I%20know%20they're%20still%20there%20and%20I%20can%20add%20to%20them%20with%20a%20reply.%20I%20was%20even%20able%20to%20go%20to%20a%20previous%20version%20from%20July%203rd%2C%20which%20displayed%20the%20comment%20pop-up%20window%20when%20hovering%20over%20the%20indicator%20and%20it%20worked%20for%20a%20little%20while%2C%20but%20then%20reverted%20again%20to%20not%20working%20online.%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20other%20Excel%20files%20we%20utilize%20in%20the%20same%20manner%2C%20and%20they%20seem%20to%20be%20working%20fine.%3C%2FP%3E%3CP%3ESome%20stats%20on%20the%20file%3A%3C%2FP%3E%3CP%3EXLSX%20file%2C%20which%20I%20have%20included.%20We%20use%20lots%20of%20filters%20and%20sheet%20views%20to%20slice%20and%20dice%20the%20rows.%3C%2FP%3E%3CP%3E1.71%20MB%3C%2FP%3E%3CP%3E3%20sheets%20-%20Main%20sheet%20has%2019%2C954%20cells%20with%20data%2C%201%20table%2C%202141%20formulas%20(simple%20date%20diff%20calcs)%2C%20720%20comments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20mostly%20Win%2010%20environment%20with%20some%20on%20laptops%2Fdesktops%20and%20some%20on%20Citrix%20VDI's.%3C%2FP%3E%3CP%3EJust%20wanting%20to%20see%20if%20anyone%20else%20has%20experienced%20anything%20like%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2525096%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2531563%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20field%20comments%20not%20displaying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2531563%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1098009%22%20target%3D%22_blank%22%3E%40Mallorysteve%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20can't%20reproduce%20that%2C%20all%20comments%20are%20visible%20in%20Excel%20for%20web%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294582iADA5DC092B9C0EFC%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2532025%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20field%20comments%20not%20displaying%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2532025%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20Sergei.%20Did%20you%20test%20in%20multiple%20browsers%3F%20After%20posting%20this%20we%20received%20word%20from%20Microsoft%20that%20something%20in%20our%20file%20was%20corrupted%20so%20I%20created%20a%20brand%20new%20Excel%20file%20and%20copied%20all%20data%20back%20into%20that%20and%20replaced%20the%20old%20file%20with%20the%20new%20(did%20not%20save%20over%2C%20renamed%2C%20moved%20and%20replaced).%20It%20worked%20for%20part%20of%20the%20day%2C%20but%20then%20the%20problem%20has%20now%20come%20back.%20I'm%20still%20discussing%20with%20Microsoft%20also%20because%20I%20could%20get%20it%20to%20work%20in%20Firefox%20yesterday%2C%20but%20not%20Chrome.%20I%20cleared%20all%20of%20my%20cache%2C%20cookies%2C%20etc.%20too%20and%20that%20did%20not%20help.%3C%2FP%3E%3CP%3EReally%20wish%20they%20could%20figure%20out%20what's%20wrong%20because%20we%20use%20this%20spreadsheet%20heavily%20in%20our%20day-to-day%20operations.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, we use O365 (E3 license) and use many shared Excel spreadsheets. One such sheet that we open mostly with web/Excel Online recently stopped displaying the field comments in the normal Pop-up display or in the Comments pane on the right-hand side when opened. We can open the file in desktop Excel and still see them so I know they're still there and I can add to them with a reply. I was even able to go to a previous version from July 3rd, which displayed the comment pop-up window when hovering over the indicator and it worked for a little while, but then reverted again to not working online. 

We have other Excel files we utilize in the same manner, and they seem to be working fine.

Some stats on the file:

XLSX file, which I have included. We use lots of filters and sheet views to slice and dice the rows.

1.71 MB

3 sheets - Main sheet has 19,954 cells with data, 1 table, 2141 formulas (simple date diff calcs), 720 comments.

 

We are mostly Win 10 environment with some on laptops/desktops and some on Citrix VDI's.

Just wanting to see if anyone else has experienced anything like this.

 

 

7 Replies

@Mallorysteve 

I can't reproduce that, all comments are visible in Excel for web

image.png

@Sergei Baklan Thank you Sergei. Did you test in multiple browsers? After posting this we received word from Microsoft that something in our file was corrupted so I created a brand new Excel file and copied all data back into that and replaced the old file with the new (did not save over, renamed, moved and replaced). It worked for part of the day, but then the problem has now come back. I'm still discussing with Microsoft also because I could get it to work in Firefox yesterday, but not Chrome. I cleared all of my cache, cookies, etc. too and that did not help.

Really wish they could figure out what's wrong because we use this spreadsheet heavily in our day-to-day operations.

Thanks.

@Mallorysteve 

Nope, in Microsoft environment I work with Edge. In other cases mainly Vivaldi, but I didn't test the file with it.

Thanks @Sergei Baklan . I tested with Edge too and getting same results.

I have the same issue as @Mallorysteve 

There is the red triangle but the comments will never show up.

It used to work perfectly fine. I haven't checked this feature since june so it seems something changed during July.

Always a pity to see these random changes by Microsoft, with no workaround.

 

lebyeom_0-1640630321868.png

 

@lebyeom yes it's been a frustrating few months on this problem. I had an ongoing support case open with Microsoft and could never get anywhere with them at all. Some of it was the support person assigned was so randomly available, never giving me notice and was out on sick days many, many times. Their final suggested resolution to me was to recreate the whole spreadsheet manually and retype 100% of the comments over again - that's literally THOUSANDS of comments with date/time stamps, which means we would lose that audit trail. I told them just to close the ticket with such a ridiculous suggestion. I believe the issue to be a size/space issue within the comments programming. I think once you get to a certain # of rows, with multiple comments, some in multiple fields, it just crashes out.

I reached the same conclusion. Past a certain number of characters in the comment fields, the comments of any cells won't show up anymore. Total failure in terms of development since it was working perfectly before.
In terms of support, you clearly see that there's a few programmers somewhere and basically zero support. I always had to find workarounds myself. Except that here, there is none, except maybe splitting sheets (I haven't tested if it was working) but what's the point if you want to have everything on a single sheet like on Excel (for desktop). Unfortunately, that's not the only issue on my side. Maybe if we wait 1 or 2 years, they'll fix it, but I guess I'd already have cancelled my account by then.