can't select the shape in excel

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.

nunu

Posted 2013-02-13T03:57:00.920

Reputation: 119

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 – 2013-02-13T09:12:20.143

Sounds like the object, sheet or workbook is locked, protected or is read only. – CharlieRB – 2013-02-13T12:49:48.727

workbook show [group] – nunu – 2013-02-14T10:11:53.940

@nunu: Can you upload your workbook? – Siddharth Rout – 2013-02-19T10:41:39.580

Answers

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.

DaveL

Posted 2013-02-13T03:57:00.920

Reputation: 11

Aha, that's why I keep finding changes in my worksheets I don't remember making. – alexmherrmann – 2014-08-14T15:35:33.673

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.

pstraton

Posted 2013-02-13T03:57:00.920

Reputation: 109