Excel wont let me create any graphs?

Question

To put it simply, Im working on a lab and Excel wont let me create any graphs and wont let me click on any of the excel chart options under the insert tab. The options are greyed out as shown in the picture. Also, I only noticed this after excel crashed.

Answer 1

1. Please see if sheet is not protected.
2. The sheets might get grouped. If they are grouped, see whether Group is appearing in the title bar. In that case, right click on a tab name and ungroup.
3. Also see that workbook is not shared.
4. Go to File > Options > Advanced and look for "Display options for this workbook". Under "For objects, show:" select "All" (instead of "Nothing (hide objects)").
5. Try saving the file as .xls and close and open. Then save it back to .xlsx and close and open.

6.Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Hence, make Excel folder blank.

Now open the file and see if the problem disappears or not.

Note - If the above path is not applicable for your installation, you need to find XLSTART path. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)

1. Open Excel
2. ALT+F11
3. If Immediate Window is not visible, type CTRL+G. Same can be also be accessed through View > Immediate Window
4. Type "? application.StartupPath" without quotes and press enter
5. You will have your path below.

Answer 2

Ciao,

can you please share the picture?

Thanks

Ugo