Excel 2010 not entering previously entered text automatically

[tex50]

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.

 

[r3plicat3]

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?

 

[tex50]

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.

 

[mikedl]

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: