That's entirely possible; I hadn't thought of that. There are cells in
Field_Rep_Time_Sheet which are not protected as the user is entering
data on that sheet. The formula that changed is on another sheet.
Hmmmm....I'll ask the user if it's possible that he inadvertently moved
one of the lines of data. He would have had to move it, as copying the
data would not have changed the formula. That must be it. I'm not sure
how to safeguard against this for the future, as there's only so much
you can do. Perhaps I should have designed the sheet with a form for
the user input rather than having them type the data in cells. Oh
well. I'll have to inform the users not to move any data on the
Field_Rep_Time_Sheet worksheet.

That's a big help. Thanks. I appreciate it.


Dave Peterson wrote:
Any chance that the 'field rep time sheet' worksheet is not protected and the
user moved cells around on that sheet (or inserted some rows)?

I've never seen excel change formulas like this.

Connie wrote:

The formula changed to the following:

+IF('Field Rep Time Sheet'!G14=0,"",'Field Rep Time Sheet'!G14)

Connie wrote:
Here's the formula:

+IF('Field Rep Time Sheet'!G11=0,"",'Field Rep Time Sheet'!G11)

The users aren't very sophisticated with Excel, so if they broke the
protection it was by accident. However, the user sent me the
spreadsheet and it was the correct version and the protection was on.
So I'm stumped. I'm sure that the users all got the same version of
the file (and as I said I confirmed for myself that the version was
correct). Any help is appreciated!

galimi wrote:
Connie,

It may be the type of link in the formula changing. You may have a network
path that included in the formula that has changed to UNC style. Please post
the formula.
--
http://HelpExcel.com

516-984-0252


"Connie" wrote:

I have a situation which occurred when a user downloaded a spreadsheet
I created for him. I sent the spreadsheet zipped in a winzip file, and
the user unzipped the spreadsheet and copied it to their desktop. One
of the formulas on one of the sheets in the spreadsheet changed, and I
can't figure out how it changed. The cell was protected, so the user
couldn't possibly have changed it. I also sent the spreadsheet to
other users in the same office and they downloaded the file to their
desktops as well. The formula was correct for the other users. I'm
trying to avoid this situation in the future, and I'm wondering if
anyone else has had a similar thing happen. Everyone is on the correct
version of Excel (2003), macros were enabled, so I can't figure out how
the formulas changed. Any suggestions would be greatly appreciated!

Connie



--

Dave Peterson