Very odd!!

Hi all, wonder if you can help me (again!).

I am comfortable with using simple formulas, using the Alt = keys to enter a formula as =SUM

I don't know how, but when I try to use that formula (ie =SUM) and enter a cell (eg D4), I am suddenly getting a drop down menu that only seems to allow certain functions to be used instead of simply using the cell reference. I'm not sure how I can explain it so have (I hope!) attached a jpg that attempts to show what is happening!

Thanks in advance of any help. I really appreciate it.

Mike

IMG_1032.JPG

Standard Excel , using "predictive" logic i.e are you going to enter SUM, SUMIF, SUMIFs, SUMPRODUCT .....

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi John, thanks for taking the time to reply. I agree - but have never had this before! It's suddenly started - previously, I've happily set up a =SUM function and manually entered the calculations I want it do by typing the cell references. Have I perhaps inadvertently enabled predictive logic and, if so, is it possible to disable it??

HI Thanks for the reply. Yes, that works but it isn't always practical. For example, I may want to add D3 and H99 together.....Plus, this is something that has suddenly started. In another reply to this thread, it was suggested that predictive logic is being used - if so, how do I stop that happening?

Have a look at File==>Options==>Formulas==>Auto Complete (in Excel 2010) .. not sure if it the same in 2003 version.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

@Zbor: apologies!!!

I think you've cracked it! I'm using Excel 2007. Only option I can see is from Office Button - Excel Options - Formulas...I've unticked the "Formula Auto Complete" box and it seems OK on the spreadsheet I'm running. I'll try a couple of others.....

Many apologies. Won't happen again!

That's understendable.
But please rename this be to something closer to your issue like:

Problem using the Alt keys to enter a formula