preserving cell format between linked documents

G

Guest

I am working in Office Excel 2003.

The contractors in my office have a special spreadsheet with two linked
sections that copy all the data entered from one form (the CC) into two other
forms (the Main and the Addendum).

In the description column of the CC form, the rows and cells are formatted
to auto-fit and wrap text; however, when something is typed into the
description column on the CC form, the description text does not wrap or
auto-fit on the Main and Addendum forms.

These forms are protected.

The input of information/description should only be performed on the CC form.

We're losing data and having to double-check everything. Do any of you know
why the form's not preserving the cell format?

If anything's unclear, let me know, and I will try to clarify. Thanks in
advance.


Regards,
T. Noonan
 
D

Dave Peterson

Formulas return values--they don't adjust formats. You have to format the
"receiving" cells the way you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fit text in cell of a protected worksheet 3
Preserved cell formatting 1
2007 Excel: text in cell becomes hidden when formatted to wrap tex 0
Preserve cell formatting as SSN 2
Make Autofit row height work with merged cells 2
Merged cell text does not wrap 1
Is Paste Special HTML broken in Excel/Office 2007? 1
How do I have a linked cell auto-size to fit the linked data? 2

Top