Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I activate the formula auditing toolbar | Excel Discussion (Misc queries) | |||
Forms toolbar is grayed out - need a check box | Excel Discussion (Misc queries) | |||
formula auditing toolbar | Excel Worksheet Functions | |||
How do I add a Formula Auditing Toolbar in Excel | Excel Discussion (Misc queries) | |||
My excel toolbar is grayed out and I can't undo it. Sheet is not. | New Users to Excel |