Convert Threaded Comments Back to Notes

%3CLINGO-SUB%20id%3D%22lingo-sub-1299342%22%20slang%3D%22en-US%22%3EConvert%20Threaded%20Comments%20Back%20to%20Notes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1299342%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CFONT%3EI'd%20like%20to%20have%20an%20external%20consultant%20share%20an%20excel%20workbook%20with%20me%2C%20so%20I've%20placed%20the%20file%20in%20a%20shared%20OneDrive%20so%20that%20we%20are%20both%20working%20on%20the%20same%20file%20at%20all%20times.%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EThe%20workbook%20is%20an%20annual%20company%20budget%2C%20which%20I%20have%20developed%20and%20expanded%20over%20many%20years.%26nbsp%3B%20There%20are%20hundreds%20of%20'Notes'%20added%20to%20cells%20within%20many%20worksheets%20(and%20for%20the%20sake%20of%20clarity%2C%20when%20I%20say%20'Notes'%2C%20I%20mean%20what%20are%20now%20called%20'Notes'.%26nbsp%3B%20I%20started%20building%20this%20budget%20workbook%20in%202002%2C%20so%20most%20of%20these%20'Notes'%20were%20really%20'Comments'%20until%20MS%20added%20the%20new%20Threaded%20Comments%20functionality%20in%202018).%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EWhen%20my%20consultant%20and%20I%20open%20the%20workbook%20in%20the%20web%20based%20version%20of%20excel%2C%20all%20my%20'Notes'%20get%20automatically%20converted%20to%20'Threaded%20Comments'%2C%20and%20we%20don't%20want%20that%20-%20we%20want%20all%20'Notes'%20to%20remain%20'Notes'.%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EI%20have%20two%20questions%3A%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3E1)%20How%20do%20we%20stop%20the%20web%20based%20version%20from%20converting%20my%20Notes%20to%20Threaded%20Comments%3F%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3E2)%20Since%20the%20web%20based%20version%20of%20excel%20has%20changed%20all%20the%20Notes%20in%20my%20workbook%20to%20Threaded%20Comments%20(and%20did%20so%20without%20asking%20me%20if%20that's%20what%20I%20wanted)%2C%20how%20do%20I%20get%20them%20all%20converted%20back%20to%20'Notes'%20(and%20obviously%20I%20don't%20want%20to%20have%20to%20undertake%20some%20manual%20process%20to%20convert%20one%20cell%20at%20a%20time.%26nbsp%3B%20As%20mentioned%20above%2C%20I%20have%20hundreds%2C%20if%20not%20thousands%2C%20of%20notes%20in%20my%20workbook%2C%20spread%20over%20many%20worksheets%2C%20so%20I'm%20looking%20for%20a%20'all%20at%20once'%20solution)%3F%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EMy%20thanks%20in%20advance%20to%20all%20who%20offer%20their%20assistance.%3C%2FFONT%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1299342%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2241748%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20Threaded%20Comments%20Back%20to%20Notes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241748%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20Did%20you%20find%20the%20answer%20to%20your%20question%20anywhere%3F%20I%20am%20facing%20the%20same%20issue%20where%20a%20colleague%20is%20using%20a%20different%20version%20of%20excel%20on%20a%20mac%20and%20is%20unable%20to%20see%20threaded%20comments.%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22ms-editor-squiggler%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Regular Visitor
I'd like to have an external consultant share an excel workbook with me, so I've placed the file in a shared OneDrive so that we are both working on the same file at all times.
 
The workbook is an annual company budget, which I have developed and expanded over many years.  There are hundreds of 'Notes' added to cells within many worksheets (and for the sake of clarity, when I say 'Notes', I mean what are now called 'Notes'.  I started building this budget workbook in 2002, so most of these 'Notes' were really 'Comments' until MS added the new Threaded Comments functionality in 2018).
 
When my consultant and I open the workbook in the web based version of excel, all my 'Notes' get automatically converted to 'Threaded Comments', and we don't want that - we want all 'Notes' to remain 'Notes'.
 
I have two questions:
 
1) How do we stop the web based version from converting my Notes to Threaded Comments?
 
2) Since the web based version of excel has changed all the Notes in my workbook to Threaded Comments (and did so without asking me if that's what I wanted), how do I get them all converted back to 'Notes' (and obviously I don't want to have to undertake some manual process to convert one cell at a time.  As mentioned above, I have hundreds, if not thousands, of notes in my workbook, spread over many worksheets, so I'm looking for a 'all at once' solution)?
 
My thanks in advance to all who offer their assistance.
1 Reply

Hi - Did you find the answer to your question anywhere? I am facing the same issue where a colleague is using a different version of excel on a mac and is unable to see threaded comments.