A unique number? Like a timestamp, or something else? What is in the 3 cells
that it "pulls from"? I believe timestamps require either macros or circular
references. If you use macros your users will generally have to click,
"Enable Macros" every time they open it. If you use a circular reference, you
will have to check the Iterations box on the Tools-Options-Calculations
tab. This can be saved with the file, but it is set by the first Excel file
that opens. So if Excel is closed, and they open your file containing
circular references, everything's file. But it they open a different file
who's Iterations box is not checked, then open your file without exiting
Excel first, they will can a circular reference error.

My advice is to decide which way you want to go and describe in greater
detail what the number should be for each file.

"WiredMike" wrote:

Im really new here so apologize if this has been asked before.
My problem is this:

I have created a template file that will be stored on a share drive company
wide.
What I need is something that when someone uses that template, it will
create a unique number in a certain cell and then not change everytime the
new .xls file is opened.
I would like to have that number pull from 3 cells if possible.

I do understand a little bit about macros from what I have learned from this
discussion group. But please if its really complicated help me with step by
step.

Thank You