Home > In Excel > Cannot Edit Comments In Excel

Cannot Edit Comments In Excel


May 31, 2013 I'd prefer to edit links with the source workbook open, however I receive this error when I do "A formula in this worksheet contains one or more invalid Strangely enough this happens with only one > worksheet. View 3 Replies View Related Home Submit Resource Tracker Forum Advance Search Privacy Policy| Terms of Use & Service| Contact Us| Copyrights Notice Copyrights 2005-15 www.BigResource.com, All rights reserved

Advertisements Latest Threads WCG Stats Sunday 06 November 2016 WCG Stats posted Nov 6, 2016 at 7:00 AM Realtek Audio Terry James posted Nov 5, 2016 at 8:20 PM Well I my review here

Can't edit a Comment, not protecting, not sharing « Previous Thread | Next Thread » Thread Tools Display Modes #1 November 10th 07, 12:37 AM posted to I have the same problem and for me it has worked. I have tried to have my code send the active cell to another cell and then back, but that doesn't seem to work. Do you have multiple worksheets grouped? -- Richard "tfletch" wrote: > I'm using Excel 2002 on XP, have been for a couple years and all of a sudden > I cannot

Can't Edit Comments In Excel 2013

is the workbook shared? "Unless otherwise stated all my comments are directed at OP" Mojito connoisseur and now happily retired where does code go ? more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Register To Reply 01-22-2015,05:13 AM #13 Babumj View Profile View Forum Posts Registered User Join Date 10-29-2014 Location qatar MS-Off Ver 2010 Posts 1 Re: Can't edit comments ... You could also try this: righ-click the cell and select "show comment".

DR Anoop S replied to DR on 09-May-10 03:09 AM 1. Over the course of a few days of trying everything unsuccessfully I once again right clicked on a cell and I couldn't see anything. View 9 Replies View Related Allow Edit Of Cell Comments But Not Move Mar 7, 2008 I need to have users be able to modify notes to various pre-set comments on The cell I have the comment on has a dropdown box, but I can't see that being a problem.

I now have to click on the cell with the comment, REVIEW > SHOW ALL COMMENTS, then click on the cell, now I can edit the comments, and then back to Is there a way to fix this "invalid reference" error so that I can edit my links with the source workbook open? Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. could you please explain me how did it work ?

Microsoft MVP - Excel Entia non sunt multiplicanda sine necessitate Register To Reply 05-08-2010,05:20 PM #5 Sardonix View Profile View Forum Posts Registered User Join Date 05-08-2010 Location San Diego MS-Off Click the Office Button and then click Excel Options button. 2. Member Login Remember Me Forgot your password? I would like a macro that will remove all comments from the sheet and revert the cells back to their original color.

  1. Just click the sign up button to choose a username and then you can ask your own questions on the forum.
  2. I tried right clicking and the toolbar but > I can no longer edit them.
  3. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.
  4. I have 100's of comments in many cells on a very large workbook.
  5. driller View Public Profile View message headers Find all posts by driller Find all threads started by driller « Previous Thread | Next Thread » Thread Tools Show Printable Version
  6. Originally Posted by muricci i dont know how could that problem solved with this basic solution but that is amazing !!!
  7. About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts.
  8. View 9 Replies View Related Excel 2010 :: Unable To Right Click For Format Cells - Insert Or Delete Sep 27, 2011 Just recently My Excel 2010 has decided to not

Unable To Edit Comment In Excel 2013

All contents Copyright 1998-2016 by MrExcel Consulting. http://www.pcreview.co.uk/threads/how-did-i-lose-ability-to-add-edit-comments-in-excel.3837597/ View 11 Replies View Related Pictures For Comments May 18, 2008 im using comments to display images for easy look upwhen i save a picture i want it to be that Can't Edit Comments In Excel 2013 View 2 Replies View Related Disable Comments Mar 3, 2008 I am sure this can be done - I found a similar thread but in a different context to what I Edit Comment In Excel Not Working If you're having a computer problem, ask on our forum for advice.

Here's what I did to be able to edit comments again, without any format or position changes. this page Player claims their wizard character knows everything (from books). Log in or Sign up PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Misc > Why can't I edit my comments in Excel? A few hours of freaking around and the nightmare is over...... Unable To Edit Comments In Excel 2007

I have a user of a workbook who insists on putting irritating red cornered comments in cells, rather than using the handy (and rather large) comments field I put in, especially PASTE SPECIAL> COMMENTS. you can float over the cell > and see the comment but you cannot edit it. > > Don't think it matters but I am using Autofilter. get redirected here Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries) Can't edit a Comment, not protecting, not sharing Author Name Remember Me?

Hi, I'm using MS Office 2007 and for some reason I can't edit the comments on some of the cells in my Excel spreadsheet. If so, try to open all filters (row numbers on the left will turn black instead of blue), and adjust one comment now., and see if it goes away. –Aganju Dec did you use data validation and not the cell comments for some of those cells??, Of course I can't tell because all you said was that you couldn't edit them... --

as you can see in the image, these options are greyed out.Running Office standard 2010, Windows 7 pro x64 View 8 Replies View Related Prevent Copy / Paste Cells With Comments

View 11 Replies View Related Unable To Edit Macro To Loop Correctly Oct 22, 2009 I need the macro I created to run (when assigned to a button) in specific sheets EXCEL Example.xlsx View 3 Replies View Related Unable To Delete 1 Million+ Rows Apr 30, 2009 I've accidentally created over 1 million rows across several sheets which has sent my file How are the functions used in cryptographic hash functions chosen? Member Login Remember Me Forgot your password?

Is adding the ‘tbl’ prefix to table names really a problem? But normally, the comment will be connected by a line to the cell, so you would just follow the line to find the comment. Everything works great except that after the user selects what they want from the userform and it hides and the focus comes back to the sheet, the comment is in edit useful reference While this is not horrible it is not as nice as I would like.

Note: I know how to print the actual comments - however, the colleague I'm assisting only wants to show that there is a comment without actually showing said comment. Please Login or Register to view this content. I have stumped as well as other forums.