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

[Jeff Lowenstein]

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?

 

[Sean Timmons]

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]

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

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.

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?

 

[Gord Dibben]

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

 

[Peo Sjoblom]

Or he could just right click any tab and select ungroup


--
Regards,

Peo Sjoblom

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

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?