ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Why would you need more the one spreadsheet for a workbook? (https://www.excelbanter.com/excel-worksheet-functions/11680-why-would-you-need-more-one-spreadsheet-workbook.html)

Excel

Why would you need more the one spreadsheet for a workbook?
 
I am doing this for computer applications and trying to get all my work done
by CST time! I need to fine out about Spreadsheets.

Dave R.

This is just my opinion, but I think there maybe some truth in it. Why else
would Microsoft have a default workbook containing 3 worksheets...

Generally it's advised to have more than one spreadsheet in a workbook. The
reason for this is that viruses can infect workbooks, and the damage done by
the virus is often less severe if it spreads over numerous worksheets rather
than "focusing" (if you will) on one. You will generally lose less data if,
god forbid, a virus finds its way into the workbook. This is why Microsoft
ships Excel with a 3 worksheet workbook. Legally, they are trying to protect
themselves from lawsuits for lost data.

Hope this helps.


"Excel" wrote in message
...
I am doing this for computer applications and trying to get all my work

done
by CST time! I need to fine out about Spreadsheets.




Harlan Grove

Excel wrote...
I am doing this for computer applications and trying to get all my

work done
by CST time! I need to fine out about Spreadsheets.


Homework? Asking others to do it for you?


Dave Peterson

I figure that if I have to take that spreadsheet home, then there's no good
reason to lug home those extra sheets. All it does is make the laptop's
harddrive heavier.



"Dave R." wrote:

This is just my opinion, but I think there maybe some truth in it. Why else
would Microsoft have a default workbook containing 3 worksheets...

Generally it's advised to have more than one spreadsheet in a workbook. The
reason for this is that viruses can infect workbooks, and the damage done by
the virus is often less severe if it spreads over numerous worksheets rather
than "focusing" (if you will) on one. You will generally lose less data if,
god forbid, a virus finds its way into the workbook. This is why Microsoft
ships Excel with a 3 worksheet workbook. Legally, they are trying to protect
themselves from lawsuits for lost data.

Hope this helps.

"Excel" wrote in message
...
I am doing this for computer applications and trying to get all my work

done
by CST time! I need to fine out about Spreadsheets.


--

Dave Peterson

Harlan Grove

Dave R. wrote...
....
Generally it's advised to have more than one spreadsheet in a

workbook. The
reason for this is that viruses can infect workbooks, and the damage

done by
the virus is often less severe if it spreads over numerous worksheets

rather
than "focusing" (if you will) on one. You will generally lose less

data if,
god forbid, a virus finds its way into the workbook. This is why

Microsoft
ships Excel with a 3 worksheet workbook. Legally, they are trying to

protect
themselves from lawsuits for lost data.

.....

And I thought I was nasty!

BTW, EULA rules!


Dave Peterson

Lots of times you have different kind of data that's related. By keeping them
in different worksheets, it makes using them easier.

I sometimes put instructions on sheet1, Sales data on sheet2, site data on
sheet3, account executive data on sheet4.

And lots of times, my coworkers will want the data for their customers on a
separate sheet. Then they can just copy that single sheet to a new workbook and
not be afraid of sharing data with the wrong customers.



Excel wrote:

I am doing this for computer applications and trying to get all my work done
by CST time! I need to fine out about Spreadsheets.


--

Dave Peterson


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com