View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Why are the tools in the Data tab unavailable?

Hi

If the sheet is protected, What IfData Table becomes unavailable.
If Excel OptionsAddinsAnalysis Toolpak is disabled, then Data Analysis is
unavailable
Other than this, I always see the the DataData Tools options available.

--
Regards
Roger Govier

"dawnaj10" wrote in message
...
I am working in a spreadsheet in 2007 and all of the features in the data
tab
have become unavailable. I need to use the What If feature. What can I
do
to turn these features back on.