data changes not saved after I save and close a spreadsheet

[Edward Letendre]

Okay, this is very confusing to me. I have a simple spreadsheet in excel
2003. I have data such as number of hours worked per day, summed up to a
weekly total and finally a grand total for each department that a manager
works with so my excel looks something like this:

hours worked

manager Fred

department day 1 day 2 day 3 day 4 day 5 weekly grand total
kids clothes 8 0 8 0 8 24
men clothes 0 0 0 0 0 0
womens clothes 8 8 8 8 8 40


grand total 64

now that I have created this spreadsheet, I need to email it to manager fred
in this case, to show the totals to Fred for this store, but say I made a
mistake in men clothes on day 1, which is a 0 now, but needs to be an 8 so I
open the spreadsheet and make the change and save it to the computer and
email it out as an attchment. but in my case, the day 1 for men clothes
should be now 8 but after the change and save to 8, it goes back to 0 on the
newly saved spreadsheet and the changes I just made are not reflected in the
saved and re-emailed spreadsheet. What would cause my problem and how do I
fix it? I was thinking of doing a detect and repair from the help menu and
seeing if there are any patches I might be missing, but why does the changes
I make to the spreadsheet not take effect even after saving and emailing them
out. This is very confusing to me.

 

[Tom Willett]

Please post in an Excel newsgroup. This is for FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
---------------------------
message : Okay, this is very confusing to me. I have a simple spreadsheet in excel
: 2003. I have data such as number of hours worked per day, summed up to a
: weekly total and finally a grand total for each department that a manager
: works with so my excel looks something like this:
:
: hours worked
:
: manager Fred
:
: department day 1 day 2 day 3 day 4 day 5 weekly grand total
: kids clothes 8 0 8 0 8 24
: men clothes 0 0 0 0 0 0
: womens clothes 8 8 8 8 8 40
:
:
: grand total
64
:
: now that I have created this spreadsheet, I need to email it to manager
fred
: in this case, to show the totals to Fred for this store, but say I made a
: mistake in men clothes on day 1, which is a 0 now, but needs to be an 8 so
I
: open the spreadsheet and make the change and save it to the computer and
: email it out as an attchment. but in my case, the day 1 for men clothes
: should be now 8 but after the change and save to 8, it goes back to 0 on
the
: newly saved spreadsheet and the changes I just made are not reflected in
the
: saved and re-emailed spreadsheet. What would cause my problem and how do
I
: fix it? I was thinking of doing a detect and repair from the help menu
and
: seeing if there are any patches I might be missing, but why does the
changes
: I make to the spreadsheet not take effect even after saving and emailing
them
: out. This is very confusing to me.

 

[Kevin]

Without seeing your spreadsheet, it is not possible to say what is happening. It
could be that you are not saving the changed spreadsheet before mailing it to
your friend or it could equally be that the original figures are derived from
other cells because of formulas used. When can we download the spreadsheet from
to see exactly what is happening.

 

[disberg]

Without seeing your spreadsheet, it is not possible to say what is happening. It
could be that you are not saving the changed spreadsheet before mailing it to
your friend or it could equally be that the original figures are derived from
other cells because of formulas used. When can we download the spreadsheet from
to see exactly what is happening.

 

[Rob Giordano [MS MVP]]

are you making the changes on the attached spreadsheet or on the original
spreadsheet?...make the changes on the original then re-attach it to new
email?