Thank you all, i converted my workbook in to the new file format and this
seems to have solved it all your sujestions helped.

mike

"Sandy Mann" wrote:

If the other suggestions do not do what you want try enclosing the elements
in double brackets instead of single ones, it will let you enter more
elements than the 30 limit, at least it does in earlier versions.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Mike7of_9" wrote in message
...
hi could any one help me with this error, i am adding up a lod of numbers
but
get this error
More arguments have been specified for this function than are allowed in
the
current file format.
is ther away to alter hao many function allowed in each cell ?
thank you for any help

mike7of_9