problem with adding column, formatting

[Burt]

I saved a workbook in quatro pro 8 to excel format and then opened it in
excel (ms office 2000). some of the columns will not permit reformatting -
changing the date format or changing from currency to accountant number
format. I can not add blank columns between columns containing data. A
window pops up indicating that Excel will not insert a column as I will lose
data. I have attempted to follow instructions in the documentation and in
the help screen but can not insert blank columns. In the transfer process
does excel end up with locked column and row structure and/or formatting of
some data that can not be changed? How do I release the "lock" and gain the
ability to edit as I wish?

 

[loadhigh]

If you use VBA Program.You can look up "Protect"(key word) in excel vba
'online help.

eg:
You want lock sheet1,then you can script this code :
Application.Workbooks(1).Protect

You want unlock sheet1,then you can script this code :
Application.Workbooks(1).Unprotect

 

[Burt]

I saved a workbook in quatro pro 8 to excel format and then opened it in
excel (ms office 2000). some of the columns will not permit reformatting -
changing the date format or changing from currency to accountant number
format. I can not add blank columns between columns containing data. A
window pops up indicating that Excel will not insert a column as I will lose
data. I have attempted to follow instructions in the documentation and in
the help screen but can not insert blank columns. In the transfer process
does excel end up with locked column and row structure and/or formatting of
some data that can not be changed? How do I release the "lock" and gain the
ability to edit as I wish?

Column problem solved. Still have a problem with inability to format some
columns of data.

 

[Burt]

I don't use VBA - can't excel unlock the worksheet?

 

[loadhigh]

You can use the menu,but my menu is chinese.

I think it would be "Protect" in the "Tools" menu .

 

[Dave Peterson]

I think I'd try copying the cells and pasting to a new worksheet (maybe in a new
workbook???)

Copy|paste special|formulas
followed immediately by Paste special|formats
(maybe even skip that second step and format it the way I want.)

A couple of times, I've had trouble formatting when excel wasn't the original
authoring tool (either Lotus 123 or Crystal Reports (in my cases)).