SORRY IF THIS IS A 2ND POSTING BY ACCIDENT BUT, IF SO,
PLEASE READ THIS ONE NOT THE PRIOR

A file I have contained one worksheet that was a cosmetically pretty echo of
another of my worksheets that was full of actual inputs, many of which I
range-named. I sent this file to a colleague who wanted me to make the
former worksheet even prettier for his client. He sent the new file back to
me but, since I was continuing with other changes, while he did it, I needed
to simply capture all his cosmetic changes in that one worksheet, which had
only results, no cells that drove anything else. So, I deleted my worksheet
and copied his in. I don't recall getting asked any questions about range
names when I did, but I may have. I then deleted his file from my computer.

In any event, whenever I create a cell with one of these "smart labels",
e..g, "with a value of "&text(v2,"0%")"&"...", where v2 is one of the
range-named input cells, when I try to hit enter, it brings up a dialog box
called "update values: his filename.xls",
looking for me to choose a filename with his filename being some other
filename on his system (his computer and mine are not linked, could it be
sitting in my
temp files?). Whatever I did next, to
deal with that EXCEL reaction, that smart cell then turned to garbage. If I
then go to insert/name/define, instead of the range names I created within
my file, I see the same names but referenced from his modified copy of the
file - to be clear he did not change any range names. I proceeded to delete
them all and then all is fine.... until I create another one of these smart
cells. Then, the problem starts all over again.

Bottom line, it seems that his range names are overtaking mine and keep
finding their way back into my file. Why is this happening and how can I
expunge his range names from my computer.

Thanks!
Dean