Problems adjusting to XP

  • Thread starter Thread starter P D Sterling
  • Start date Start date
P

P D Sterling

I'm a moderately experienced user with two complaints:

1) I accidentally set the 'recently used file list' to zero, and I meant
one. In the Options or wherever it is, now, the box is grayed out and I
can't get it re-set to 1. Halp!!

2) 97% of my work is with mini-databases which I prefer to have in Excel,
and the new Excel keeps reminding me and scolding me for having text labels
which appear to be numbers [duh!!] And it scolds me when I sort. How can I
tell Excel to stop treating me like an idjit?
 
Many thanks - I guess it was checked, thinking it was something operating in
the background - anyway, I am happier than I was before!! :-)
--
Regards,

P D Sterling
www.pdsterling.us
--
Don I said:
1) No Idea

2) Tools>Options>Error Checking>Uncheck "Enable BG error checking".
P D Sterling said:
I'm a moderately experienced user with two complaints:

1) I accidentally set the 'recently used file list' to zero, and I meant
one. In the Options or wherever it is, now, the box is grayed out and I
can't get it re-set to 1. Halp!!

2) 97% of my work is with mini-databases which I prefer to have in Excel,
and the new Excel keeps reminding me and scolding me for having text
labels which appear to be numbers [duh!!] And it scolds me when I sort.
How can I tell Excel to stop treating me like an idjit?
--
Regards,

P D Sterling
www.pdsterling.us
Click to expand...
Click to expand...
 
well tweak my a** - you are good, and I must have been tired when I hit that
button. thanks for the tip!!!
--
Regards,

P D Sterling
www.pdsterling.us
--
Gord Dibben said:
1. How did you set it to zero?

My Excel 97, 2002 and 2003 complain that it "must be a number between 1
and
9".

I can uncheck the option but cannot enter a zero.

Are you running TweakUI?

If so, you may have disabled the MRU lists by unchecking "maintain
document
history list" under the Explorer tab.

Read more potential causes here..........

http://groups.google.ch/groups?hl=de&lr=&ie=UTF-8&selm=#OB7jndUBHA.2008@tkmsftngp0


Gord Dibben Excel MVP

I'm a moderately experienced user with two complaints:

1) I accidentally set the 'recently used file list' to zero, and I meant
one. In the Options or wherever it is, now, the box is grayed out and I
can't get it re-set to 1. Halp!!

2) 97% of my work is with mini-databases which I prefer to have in Excel,
and the new Excel keeps reminding me and scolding me for having text
labels
which appear to be numbers [duh!!] And it scolds me when I sort. How can I
tell Excel to stop treating me like an idjit?
Click to expand...
Click to expand...
 
Back
Top