Excel 2010 not entering previously entered text automatically

Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn it on always. Hope this is clear enough. Help appreciated.

tex50 said:

Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn it on always. Hope this is clear enough. Help appreciated.

Can you post a screenshot of what it looks like when it duplicates correctly?

r3plicat3 said:

tex50 said:

Excel 2010. Win 7 ultimate. Excel will duplicate text as I type within the same session that I originally entered the text to the spreadsheet. However, if I close the file and then reopen it it won't automatically enter text as I type of previously entered cells. Can't seem to find option to turn it on always. Hope this is clear enough. Help appreciated.

Can you post a screenshot of what it looks like when it duplicates correctly?

Its just a duplicate of what I typed earlier filled in automatically after I enter a couple of letters.

Hi, tex50, welcome to the Seven Forums! :)

Go to the "File" tab and the click on "Options":



Then check this setting in the "Advanced" options section of Excel 2010: