excel problem

[sentme_mail]

hi,
i have a being using an excel file in excel97 whereby i can press "ctrl A" and it will do some calculations for me.
But now it doesn't work in excel 2000.
any help?
thanks

 

[Yankee Rose]

Hi there -

You've typed a function name into the cell first?

 

[sentme_mail]

whats function name ??

 

[Yankee Rose]

Microsoft's web site on Excel 2000:

"Ctrl-A - "When you enter a formula, display the Formula Palette after you type a function name".

Probably the easiest way to explain it is when you are in Excel 2000, click your Help and type in <b>formula palette function name</b> then click the "About using the Formula Palette to enter and edit functions".

It explains what ya need to do pretty well.

Hope that helps!

 

[sentme_mail]

whenever i open the file, it pops up an error box saying:
Run-time error '28':
out of stack space.
i have an option to click "end" or "debug"
when i click on debug it opens MS visual basic and shows:
Private Sub Worksheet_Calculate()
RefreshFormula
End Sub

any idea?

 

[Yankee Rose]

Take a look <a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;266156">here</a>.

If that doesn't pertain, then try <a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;264658">this one</a>.

Hope these help!

 

[sentme_mail]

i don't understand
http://support.microsoft.com/default.aspx?scid=kb;en-us;266156
because i am not a programmer.

 

[Yankee Rose]

OK .... I'll back up a bit.

This error is occurring only in one particular Excel file you are trying to open, correct?

I am assuming this is a file that someone else created, and you are trying to open it, never having opened it before?