ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What if analysis icon is not available (https://www.excelbanter.com/excel-worksheet-functions/253277-what-if-analysis-icon-not-available.html)

Kmn

What if analysis icon is not available
 
My class is working with Goal Seek. They go to the Data tab and most of the
icons are gray shaded and can't be clicked on. One of them is the What If
analysis where we pick the Goal Seek. The next student is fine and has all
icons available. Help!

Bernard Liengme[_2_]

What if analysis icon is not available
 
Have then started to type into a cell and not completed the operation with
ENTER?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"KMN" wrote in message
...
My class is working with Goal Seek. They go to the Data tab and most of
the
icons are gray shaded and can't be clicked on. One of them is the What If
analysis where we pick the Goal Seek. The next student is fine and has
all
icons available. Help!



Ashish Mathur[_2_]

What if analysis icon is not available
 
Hi,

They may be editing a certain entry (via F2 or the cursor may be in the
formula bar)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"KMN" wrote in message
...
My class is working with Goal Seek. They go to the Data tab and most of
the
icons are gray shaded and can't be clicked on. One of them is the What If
analysis where we pick the Goal Seek. The next student is fine and has
all
icons available. Help!




All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com