"Dave F" wrote in message
...
Well, let's make sure we're talking about the same thing here. You refer
to
the "whole worksheet" but I think you're really asking whether the whole
workbook is saved when you hit the save button.

If you have Sheet 1 active and you click the save button, then that
*workbook* will be saved, including any modifications made to other
worksheets in the workbook.

However, other workbooks you have open will remain unaffected.

Dave
--
Brevity is the soul of wit.


"willie091028" wrote:

When I'm working on a worksheet/spreadsheet that has numerous tabs, if I
save
on one of the spreadsheet/tabs, will it save the whole worksheet? Eg.
If I
change something on Sheet 1 and then go to Sheet 5 and change something,
then
I save on Sheet 5, will the changes on Sheet 1 also be saved?

That raises an interesting, if rather academic, question: What is the
definition of "spreadsheet", "workbook" and "worksheet". These are all
terms we glibly use assuming the recipient knows what we (think we) know.

My take on it (but I may be wrong) is -
I have googled for an answer but there seems to be no consistent answers

Spreadsheet / workbook - the whole file
www.ncsu.edu/it/edu/excel_trng/preparing.html
Spreadsheet / worksheet - the whole file
www.ncsu.edu/it/edu/excel_trng/preparing.html

Perhaps we shouldn't go so far as to ask whether these should be hyphenated!

Regards.

Bill Ridgeway
Computer Solutions