What would cause the formula auditing toolbar to be grayed out?
 

I have a workbook where the following is occuring:
1) The formula Auditing toolbar is grayed out
2) The title now includes [Group], but no sharing has been enabled
3) The protection options: Protect Sheet, and Allow users to edit ranges
are grayed out.

I have tried repairing the file with no results.
Any suggestions?

What would cause the formula auditing toolbar to be grayed out?
 

Sounds like you have multiple tabs at the bottom selected.

If all are selected, just click on one that is not bold.

If only a few are selected, click on a tab that hasn't been selected.

"Jeff Lowenstein" wrote:

I have a workbook where the following is occuring:
1) The formula Auditing toolbar is grayed out
2) The title now includes [Group], but no sharing has been enabled
3) The protection options: Protect Sheet, and Allow users to edit ranges
are grayed out.

I have tried repairing the file with no results.
Any suggestions?

What would cause the formula auditing toolbar to be grayed out
 

Thanks for the suggestion, but it didn't work.

"Sean Timmons" wrote:

Sounds like you have multiple tabs at the bottom selected.

If all are selected, just click on one that is not bold.

If only a few are selected, click on a tab that hasn't been selected.

"Jeff Lowenstein" wrote:

I have a workbook where the following is occuring:
1) The formula Auditing toolbar is grayed out
2) The title now includes [Group], but no sharing has been enabled
3) The protection options: Protect Sheet, and Allow users to edit ranges
are grayed out.

I have tried repairing the file with no results.
Any suggestions?

What would cause the formula auditing toolbar to be grayed out?
 

You have more than one worksheet selected.

That's why the [Group] in the title bar.

The grouped sheets tabs should be white.

Make note of which tabs are grouped.

Click on any non-white tab to get out of group mode.

Note: While grouped, whatever you did to one sheet in the group will have been
done to all.

Check carefully for inadvertant entries and other functions you may have done.


Gord Dibben MS Excel MVP

On Wed, 8 Aug 2007 08:04:12 -0700, Jeff Lowenstein
wrote:

I have a workbook where the following is occuring:
1) The formula Auditing toolbar is grayed out
2) The title now includes [Group], but no sharing has been enabled
3) The protection options: Protect Sheet, and Allow users to edit ranges
are grayed out.

I have tried repairing the file with no results.
Any suggestions?

What would cause the formula auditing toolbar to be grayed out?
 

Or he could just right click any tab and select ungroup


--
Regards,

Peo Sjoblom


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
You have more than one worksheet selected.

That's why the [Group] in the title bar.

The grouped sheets tabs should be white.

Make note of which tabs are grouped.

Click on any non-white tab to get out of group mode.

Note: While grouped, whatever you did to one sheet in the group will have
been
done to all.

Check carefully for inadvertant entries and other functions you may have
done.


Gord Dibben MS Excel MVP

On Wed, 8 Aug 2007 08:04:12 -0700, Jeff Lowenstein
wrote:

I have a workbook where the following is occuring:
1) The formula Auditing toolbar is grayed out
2) The title now includes [Group], but no sharing has been enabled
3) The protection options: Protect Sheet, and Allow users to edit ranges
are grayed out.

I have tried repairing the file with no results.
Any suggestions?