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?

yes, it's the workbook that is saved

Regards

Trevor


"willie091028" wrote in message
...
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?

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?

"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

A worksheet can't exist independently of a workbook. When you do a save, you
are saving the workBOOK, not any particular sheet, and all sheet are saved.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"willie091028" wrote in message
...
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?

I have googled for an answer but there seems to be no consistent answers

I don't think, at least within the world of Excel, there is any ambiguity
between "worksheet" and "workbook", at least among people who know they're
talking about. That said, I never use the word "spreadsheet" because it
sounds to Lotus-like to my ears and because it could be construed as either
a workbook or worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Bill Ridgeway" wrote in message
...
"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