 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008cannot use auditing tools
i have an excel 2002 spreadsheet that is not protected, but the auditing tools are unusable [faded out]. why? Tonso > i have an excel 2002 spreadsheet that is not protected, but the > auditing tools are unusable [faded out]. why? > Tonso Also, the drawing tools are not hightlighted either. Tonso What do you consider as a "spreadsheet"? A workbook or a worksheet within a workbook? Sounds to me like your worksheet is protected under Tools>Protection>Protect Sheet. Gord Dibben MS Excel MVP >> i have an excel 2002 spreadsheet that is not protected, but the >> auditing tools are unusable [faded out]. why? >> Tonso > >Also, the drawing tools are not hightlighted either. >Tonso > What do you consider as a "spreadsheet"? > [quoted text clipped - 13 lines] > > - Show quoted text - Gord, I meant worksheet. To be exact, the workbook in question has 6 worksheets, none of which are protected. On every sheet, the auditing tools (trace precedents, trace dependents), along with drawing tools (cirlces, rectangle, lines, etc.) cannot be accessed. Cells can be merged, formatted, borders added, but no trace precedents/trace dependents, which is what I want to do. I tried protecting and then unprotecting the worksheets. Tonso Without protecting a sheet, I can't find a way to replicate your problem in version 2003. Something both of us are missing......hopefully we will get some more suggestions from the group. Gord >Gord, >I meant worksheet. To be exact, the workbook in question has 6 [quoted text clipped - 5 lines] >unprotecting the worksheets. >Tonso Try View > Toolbars > Customize... > Reset No drawing objects or multiple tabs selected? Try Copy all to a new sheet Check out http://www.mvps.org/dmcritchie/excel/grayedout.htm http://www.mvps.org/dmcritchie/excel/toolbars.htm HTH Patrick Tonso, Could it be that you have several sheets selected, after the workbook name at the top of the excel window does it have [group]. If so right click on one of the sheet tabs and click on ungroup sheets. Barbara. >i have an excel 2002 spreadsheet that is not protected, but the > auditing tools are unusable [faded out]. why? > Tonso On Jan 6, 4:07 am, "Barbara Wiseman" <this.is....@real.email.address> wrote: > Tonso, > Could it be that you have several sheets selected, after the workbook name [quoted text clipped - 7 lines] > > - Show quoted text - No, there are no grouped sheets. Tonso On Jan 6, 4:07 am, "Barbara Wiseman" <this.is....@real.email.address> wrote: > Tonso, > Could it be that you have several sheets selected, after the workbook name [quoted text clipped - 7 lines] > > - Show quoted text - There are several workbooks that are linked to this workbook. Tonso |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.