Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2022, 09:56 AM
skeezix skeezix is offline Comments Seem to be Disabled in Some Files Windows 10 Comments Seem to be Disabled in Some Files Office 97-2003
Competent Performer
Comments Seem to be Disabled in Some Files
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default Comments Seem to be Disabled in Some Files

I can insert comments into the worksheets of most of my Excel 2000 files at any time. But some files in which I have already inserted comments, I cannot insert a new comment in any of the file's worksheets. When I select and then right-click on a cell that is formatted as "General" there is no "Insert Comment". And if I select and right-click on a comment there isn't any way to edit it.

I've checked in Tools>Options>View and verified that "Comment indicator only" is enabled. I can't find any other option about Comments in the Excel Help file.



I've noticed that "[Group]" appears after the filename in the Title bar (see attachment) in files that have the problem, so that must have something to do with the problem.
1. How do I get rid of the [Group] in the title bar?

2. How can I enable Comments in those files?
Attached Images
File Type: jpg Excel Group in Title Bar.jpg (83.0 KB, 9 views)
__________________
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.4123; Office 2000
Reply With Quote
  #2  
Old 03-09-2022, 11:00 AM
skeezix skeezix is offline Comments Seem to be Disabled in Some Files Windows 10 Comments Seem to be Disabled in Some Files Office 97-2003
Competent Performer
Comments Seem to be Disabled in Some Files
 
Join Date: Jan 2019
Posts: 100
skeezix is on a distinguished road
Default

Fixed!
To remove the "Group" word from the Title bar I first selected all of the worksheets in one of the problem files. Then I right-clicked and lo and behold, "Ungroup" appeared in the menu. I clicked that and then the word "Group" was removed from the filename in the Title bar.


I have not the foggiest idea how that word appeared, but I must have done something in the last couple of months to make it appear. Anyhow, the file is now "ungrouped" and I am happy-happy.
__________________
* HP Pavilion Desktop 510-p114
* Windows 10 Home 22H2 19045.4123; Office 2000

Last edited by skeezix; 03-10-2022 at 07:44 AM.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comments Seem to be Disabled in Some Files Error 4605 when looping through files in folder and deleting comments Peterson Word VBA 2 04-19-2018 08:45 AM
Macros are disabled gstech Excel Programming 1 12-06-2017 10:28 AM
Converting 'comments' into text files (2 questions) Paul Lance Word 1 04-29-2013 06:00 PM
Comments Seem to be Disabled in Some Files comments disappear in docx files techwriterrc12 Word 4 03-13-2013 07:05 AM
Editing disabled ubns Word VBA 0 08-30-2012 12:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft