SAVE in Excel Windows 7

[BJS]

I have numerous work books containing several worksheets. Have always used the Save button on the Quick Access toolbar to save entries made in a worksheet before moving on to the next sheet Found out by accident yesterday that although the Save button was used you can still undo any previous saved material so if, undoing any work you wish to correct in the sheet currently being worked on, you could in error in using the undo button too many times delete information "saved" in the previous worked on worksheet. This to me, seems absurd. Am I missing something here any help appreciated.

[boxtops]

I've never known this - but then I save my spreadsheets as different date versions so I'm only ever working on one which is at the most a few days old. Most I save each day with a new date in the title (as my work means I need to know variations day to day).

[rojash]

Nothing to do with Windows 7.
An Excel spreadsheet is a single document. When you save, you are not saving a worksheet, you are saving the whole document, not just the worksheet that you happen to be working on, just as in (say) Word, if you click save you are saving the whole document, not just the page you happen to be working on. Because you are working on a single document, it's possible to undo any changes on any page (or worksheet) that you have made in the current session.

[BJS]

Iunderstand that by using the Save button you are saving any cjhanges made to the whole workbook at that moment in time. What I was trying to say I could not understand is that sat you have carried out 50 new inputs/changes in the workbook and want to save them before say doing another 50 it appears you have to Save, exit the workbook and re-enter to do the next 50. which in my old wrinkled brain seens crazy. Why if you so desire cannot we Save after each entry if so desired.

[BJS]

Forgot to clarify I have the Excel 2010 version not sure if that makes a difference.

[rojash]

There's nothing crazy about it at all, as long as you grasp the fact that every time you save, you save the entire workbook. If you save it with the same name, then it will overwrite the previous workbook.

Step 1: You make some changes.
Step 2: You save the workbook - overwriting the previous version.
Step 3: You make some more changes.
Step 4: You save the workbook overwriting the previous version - the current version will now reflect ALL then changes you made after Step 2. If those changes include undoing some earlier operations, then those earlier operations will be cancelled.

[BJS]

Again, I understand what you are saying but what I can't get my head around is that in my tiny mind when the Save button is used, it means what it says, all the information in that workbook is now safe permently and safe from any error in using the Undo button before the workbook is actually closed and will not affect any data entered before that Save was used. At the moment what I am doing, is entering my data which can be quite lengthy at times and if sure of data entered, I Save and close the workbook and open it again and carry on updating new data knowing I cannot change already entered data unless I wish to, which seems very long winded to me