Excel what if analysis grayed out

It is available on a new document, when I first open it, but on the document that I am currently working on, now that I have some data to analyse, and now that I want to do a "what if analysis," when I click on the data tab, it is all gray and nothing works. Incidentally, the same thing goes for the insert tab right now. What have I done wrong? This thread is locked.

You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :. When an Excel sheet is protected, various icons and features of the program will be disabled. With exception to few icons in the Data tab, most of them will be grayed out or not clickable. A picture is given below. If the Unprotect Sheet icon is visible, it means that the Sheet is currently protected.

Click on the Unprotect Sheet icon and enter the password to make all the Data tab icons functional again. Hope this helps. Please use the comments form to let us know if something else worked out for you. I have never seen this problem before, but I was using a spreadsheet created by someone else. Did you mean:. All forum topics Previous Topic Next Topic. ChrisDenver Frequent Visitor. Thanks for your help! Message 1 of 7. Message 2 of 7. Anyone knows how to solve this issue?

Thank you! Message 7 of 7. TitikshaGanjoo Frequent Visitor. In response to deepu Hi, The new paramter tab is disabled in case of data import as well, pls suggest. Regards, Titiksha. Message 6 of 7. I wanted to follow up in case someone else had this issue. Message 5 of 7. Message 3 of 7. In response to ChrisDenver