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