View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Malin D Malin D is offline
external usenet poster
 
Posts: 5
Default Custom list limited to 255 characters? (XL 2007)

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