I have a problem today that is the first time I meet it. I have opened an old file (this file from 2005), then this contain of flowchart which made from excel's autoshape. Then I want to make some revision for this file, But I have a problem when I want to select this shapes.

Before select (click the shape), I'm highlighted the shape using my mouse but my kursor icon change into (stop icon). So, this shapes can't be highlighted or selected.

Thanks for any advice.

  • Have you considered that your workbook is damaged in some way? Sometimes copying the whole sheet to a new workbook helped people. Also have a look at microsofts advices for repairing Workbooks – nixda Feb 13 '13 at 9:12
  • Sounds like the object, sheet or workbook is locked, protected or is read only. – CharlieRB Feb 13 '13 at 12:49
  • workbook show [group] – nunu Feb 14 '13 at 10:11
  • @nunu: Can you upload your workbook? – Siddharth Rout Feb 19 '13 at 10:41

Check to see if you have more than one worksheet selected at the same time. You won't be able to select shapes when you have more than one worksheet active.

  • Aha, that's why I keep finding changes in my worksheets I don't remember making. – alexmherrmann Aug 14 '14 at 15:35

I have seen Excel 2013 get into a state in which it thinks multiple sheets are selected even though there is no visual indication that that is so. In that case, just right-click the active sheet's tab and select Ungroup Sheets.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.