Excel wont let me create any graphs? - Microsoft Community
to put simply, im working on lab , excel wont let me create graphs , wont let me click on of excel chart options under insert tab. options greyed out shown in picture. also, noticed after excel crashed.
1. please see if sheet not protected.
2. sheets might grouped. if grouped, see whether group appearing in title bar. in case, right click on tab name , ungroup.
3. see workbook not shared.
4. go file > options > advanced , "display options workbook". under "for objects, show:" select "all" (instead of "nothing (hide objects)").
5. try saving file .xls , close , open. save .xlsx , close , open.
6.please c:\users\user_name\appdata\roaming\microsoft\excel (replace user name user name, can directly reach here copy , pasting following without quotes in explorer address bar - "%appdata%\microsoft\excel") , see if contains few files / folders. move files other location (i.e create backup of files / folders , delete files / folders here). hence, make excel folder blank.
open file , see if problem disappears or not.
note - if above path not applicable installation, need find xlstart path. excel folder contains xlstart folder in (in case, xlstart path not in appdata)
1. open excel
2. alt+f11
3. if immediate window not visible, type ctrl+g. same can accessed through view > immediate window
4. type "? application.startuppath" without quotes , press enter
5. have path below.
2. sheets might grouped. if grouped, see whether group appearing in title bar. in case, right click on tab name , ungroup.
3. see workbook not shared.
4. go file > options > advanced , "display options workbook". under "for objects, show:" select "all" (instead of "nothing (hide objects)").
5. try saving file .xls , close , open. save .xlsx , close , open.
6.please c:\users\user_name\appdata\roaming\microsoft\excel (replace user name user name, can directly reach here copy , pasting following without quotes in explorer address bar - "%appdata%\microsoft\excel") , see if contains few files / folders. move files other location (i.e create backup of files / folders , delete files / folders here). hence, make excel folder blank.
open file , see if problem disappears or not.
note - if above path not applicable installation, need find xlstart path. excel folder contains xlstart folder in (in case, xlstart path not in appdata)
1. open excel
2. alt+f11
3. if immediate window not visible, type ctrl+g. same can accessed through view > immediate window
4. type "? application.startuppath" without quotes , press enter
5. have path below.
Office / Excel / Other/unknown / Office 2016 for Mac
Comments
Post a Comment