P
Tue Mar 15 16:54:49 CST 2005
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" <gorddibbATshawDOTca> wrote in message
news:3aie319jvpn98n3u1usljakauck7o3k7rs@4ax.com...
> 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=%23OB7jndUBHA.2008%40tkmsftngp0
>
>
> Gord Dibben Excel MVP
>
> On Tue, 15 Mar 2005 19:03:39 GMT, "P D Sterling"
> <pdsterling@earthlink.net>
> wrote:
>
>>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?
>