Formatting prolem in Excel

[cspm2003]

Hi all,

I have a formatting problem with Excel that I hope some of you could maybe help me with:

I have a Excel worksheet with some text fields, nothing fancy. Ive sent the document to someone via email, they fill it out and send it back to me.
This works with everyone except one person. to 80 % , when I get the Excel scheet back, The size of some rows, columns, textfields have changed, or the allignement of text within cells and I dont know why this is happening. We are both using office 2000 with service pack 3.

any suggestions?

 

[SkipVought]

Hi,

Could it be that this user tinkers with the formatting?

Is this a big problem?

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[xlbo]

the other user has manually changed the settings

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[cspm2003]

hi, thx for the quick replys.

the user was the only thing I could think of, cause it doesnt make any sence.

Yeah, its a big problem

 

[xlbo]

Have you asked the other user about this ??

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[SilentAiche]

cspm2003,

Protect the document and the user can't change row height, column width, font size/color, etc.

First, unlock the protection on the data entry cells needed by the user (Format / Cells / Protection tab).

Then, protect the document using Tools / Protection / Protect Sheet and [blue]assign a password[/blue].

This should solve the problem of the user making unwanted changes.

Hope this helps.
Tim

[blue]__________________________________________________
If you need immediate assistance, please raise your hand.[/blue]

 

[cspm2003]

xlbo, yes, I have asked the user and he said he didnt change anything

SilentAiche, thx for the tip, Im going to try it out tomrow when Im at work and get back to you

 

[cspm2003]

SilentAiche,

I just tryed it out, and it seams like this is what I need. Thanks!

 

[SilentAiche]

Glad it worked!

Tim

[blue]__________________________________________________
If you need immediate assistance, please raise your hand.[/blue]