Why is trace precedents disabled in Excel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 20 Mar 2008 17:59 GMT

I don't know what's wrong. it's a simple spreadsheet. I love that MS makes
something easy difficult. If anyone knows how to enable this on simple
spreadsheets that would be great, if you also have some idea why I had to
waste a bunch of time finding out how to do something that was completely
easy in 2003 that would be even cooler. It would give me some idea how to
think about these things in 2007. oh yes I saved the spreadsheet from an xls
to xlsx and reopened it to get out of compatibility mode.

Reply to this Message

Jim Rech - 20 Mar 2008 18:16 GMT

If the sheet is protected (on the Review tab) Trace Precedents will be
disabled. Might be something else of course...

If you really want to know why MS went with the ribbon...

http://msstudios.vo.llnwd.net/o21/mix08/08_WMVs/UX09.wmv

I got this link from http://blogs.msdn.com/jensenh/

Signature

Jim

|I don't know what's wrong. it's a simple spreadsheet. I love that MS makes
| something easy difficult. If anyone knows how to enable this on simple
[quoted text clipped - 3 lines]
| think about these things in 2007. oh yes I saved the spreadsheet from an xls
| to xlsx and reopened it to get out of compatibility mode.

Reply to this Message

Bill - 20 Mar 2008 20:44 GMT

Thanks a bunch, that was perfect. I didn't think of it since I hardly ever
use protection in the 2003 version. I found it pretty difficult. This
spreadsheet was sent to me and had it on. I'll check out the video because
the frustration level is pretty high right now and I'm usually one who can
find my way around pretty quickly. Of course I used the help before I came
here and while it told me all about precendents no where did I find it
addressing the disable of the options.

thanks agin

> If the sheet is protected (on the Review tab) Trace Precedents will be
> disabled. Might be something else of course...
[quoted text clipped - 14 lines]
> xls
> | to xlsx and reopened it to get out of compatibility mode.

Reply to this Message