Prev: create a separate list for unique records
Next: Referring the cell instead of typing the sheet name
From: Malin D on 28 Apr 2010 05:51
I have a client who claims that she could create longer custom lists in Excel
2003 compared to the limit of 255 characters that she managed to Exceed when
trying to regain her customizations in the newly installed Office.

It seems as if she is right? Anyone else who had this problem or can point
me towards a better solution?
--
Best regards

Malin D
Office consultant/Trainer
From: trip_to_tokyo on 28 Apr 2010 06:42
EXCEL 2007

Hit F1 to launch the F1 Help Facility

Type in:-

EXCEL Specifications And Limits

- in the Search box then hit Search.

Inspect the topic.

Ctrl-F to lauch Find then, in the find field, type in:-

custom

This returns a FEATURE of Custom functions giving a MAXIMUM LIMIT of:-

Limited by available memory

If my comments have helped please hit Yes.





"Malin D" wrote:

> I have a client who claims that she could create longer custom lists in Excel
> 2003 compared to the limit of 255 characters that she managed to Exceed when
> trying to regain her customizations in the newly installed Office.
>
> It seems as if she is right? Anyone else who had this problem or can point
> me towards a better solution?
> --
> Best regards
>
> Malin D
> Office consultant/Trainer
From: Malin D on 29 Apr 2010 04:51
But this is not a custom function it is a built in list? What I am trying to
figure out is if this limit is a new limit in XL2007 or if it was limited to
the same size in 2003 (which my rather skilled client claims.)

I have scanned the entire limit page in the help feature but I don't think
that this feature is listed.

Thanks for your help so far.
--
Best regards

Malin D
Office consultant/Trainer


"trip_to_tokyo" wrote:

> EXCEL 2007
>
> Hit F1 to launch the F1 Help Facility
>
> Type in:-
>
> EXCEL Specifications And Limits
>
> - in the Search box then hit Search.
>
> Inspect the topic.
>
> Ctrl-F to lauch Find then, in the find field, type in:-
>
> custom
>
> This returns a FEATURE of Custom functions giving a MAXIMUM LIMIT of:-
>
> Limited by available memory
>
> If my comments have helped please hit Yes.
>
>
>
>
>
> "Malin D" wrote:
>
> > I have a client who claims that she could create longer custom lists in Excel
> > 2003 compared to the limit of 255 characters that she managed to Exceed when
> > trying to regain her customizations in the newly installed Office.
> >
> > It seems as if she is right? Anyone else who had this problem or can point
> > me towards a better solution?
> > --
> > Best regards
> >
> > Malin D
> > Office consultant/Trainer
From: ozgrid.com on 29 Apr 2010 05:08
I don't think anyone understands the problem or what you are trying to do.



--
Regards
Dave Hawley
www.ozgrid.com
"Malin D" <MalinD(a)discussions.microsoft.com> wrote in message
news:AD722605-4CE1-41EE-AB65-A56F439A928C(a)microsoft.com...
> But this is not a custom function it is a built in list? What I am trying
> to
> figure out is if this limit is a new limit in XL2007 or if it was limited
> to
> the same size in 2003 (which my rather skilled client claims.)
>
> I have scanned the entire limit page in the help feature but I don't think
> that this feature is listed.
>
> Thanks for your help so far.
> --
> Best regards
>
> Malin D
> Office consultant/Trainer
>
>
> "trip_to_tokyo" wrote:
>
>> EXCEL 2007
>>
>> Hit F1 to launch the F1 Help Facility
>>
>> Type in:-
>>
>> EXCEL Specifications And Limits
>>
>> - in the Search box then hit Search.
>>
>> Inspect the topic.
>>
>> Ctrl-F to lauch Find then, in the find field, type in:-
>>
>> custom
>>
>> This returns a FEATURE of Custom functions giving a MAXIMUM LIMIT of:-
>>
>> Limited by available memory
>>
>> If my comments have helped please hit Yes.
>>
>>
>>
>>
>>
>> "Malin D" wrote:
>>
>> > I have a client who claims that she could create longer custom lists in
>> > Excel
>> > 2003 compared to the limit of 255 characters that she managed to Exceed
>> > when
>> > trying to regain her customizations in the newly installed Office.
>> >
>> > It seems as if she is right? Anyone else who had this problem or can
>> > point
>> > me towards a better solution?
>> > --
>> > Best regards
>> >
>> > Malin D
>> > Office consultant/Trainer

From: Dave Peterson on 29 Apr 2010 07:51
I created a string of 369 characters -- 10 elements of 36 characters each plus
the 9 comma separators.

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
ABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
ACCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
ADDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD
AEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
AFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
AGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
AIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
AJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJ

I used xl2003 and could create that custom list successfully via the
Tools|Options|Custom Lists dialog box.

I loaded up xl2007 and tested it with the same stuff (excel
options|Popular|create custom list dialog). It failed and gave me a warning
that only the first 255 characters would be kept.

So the limit sure looks like it changed between versions.

==========

But that doesn't mean she should give up.

I could still make a custom list longer than 255 in xl2007 (and xl2003, by the
way) by picking it up from a range.





Malin D wrote:
>
> But this is not a custom function it is a built in list? What I am trying to
> figure out is if this limit is a new limit in XL2007 or if it was limited to
> the same size in 2003 (which my rather skilled client claims.)
>
> I have scanned the entire limit page in the help feature but I don't think
> that this feature is listed.
>
> Thanks for your help so far.
> --
> Best regards
>
> Malin D
> Office consultant/Trainer
>
> "trip_to_tokyo" wrote:
>
> > EXCEL 2007
> >
> > Hit F1 to launch the F1 Help Facility
> >
> > Type in:-
> >
> > EXCEL Specifications And Limits
> >
> > - in the Search box then hit Search.
> >
> > Inspect the topic.
> >
> > Ctrl-F to lauch Find then, in the find field, type in:-
> >
> > custom
> >
> > This returns a FEATURE of Custom functions giving a MAXIMUM LIMIT of:-
> >
> > Limited by available memory
> >
> > If my comments have helped please hit Yes.
> >
> >
> >
> >
> >
> > "Malin D" wrote:
> >
> > > I have a client who claims that she could create longer custom lists in Excel
> > > 2003 compared to the limit of 255 characters that she managed to Exceed when
> > > trying to regain her customizations in the newly installed Office.
> > >
> > > It seems as if she is right? Anyone else who had this problem or can point
> > > me towards a better solution?
> > > --
> > > Best regards
> > >
> > > Malin D
> > > Office consultant/Trainer

--

Dave Peterson
 | 
Pages: 1
Prev: create a separate list for unique records
Next: Referring the cell instead of typing the sheet name