Column Widths

Ted Wiebe · May 21st, 2002, 03:07 PM

I'm racking my brain. I have one Excel workbook that I've taken over from a former co-worker. Whenever I open this book, the column width is not the same as when I last saved it. For example I have 4 columns all 18 wide, but when I save , close and then re-open, the columns are back at 15.29.

Any help would be appreciated

Thanks

Rocky E · May 21st, 2002, 03:31 PM

Have you looked at Format, Columns, Set Width.

Ted Wiebe · May 21st, 2002, 03:36 PM

I've tried that, however, all other types of formatiing saves, except for when I change these column widths. I've got no Idea why.

PaddyD · May 21st, 2002, 04:12 PM

Ted,

If it's really a problem, you could consider setting the column widths explicitly using the ColumnWidth property in VB.
I know precisely no VB, but I'm sure someone out there would chip in with a bit of code...

Paddy

SamS · May 21st, 2002, 04:20 PM

have you looked at the worksheet module - right click on the worksheet tab and select view code - there is probably some vba code in there that is resetting the column width on you

jkpd2000 · May 21st, 2002, 04:26 PM

click above 1 , which will highlight the entire sheet.

then in the menu select format,column, width
then set to what ever width you want

[ This Message was edited by: jkpd2000 on 2002-05-21 15:27 ]

WayneTN · May 21st, 2002, 05:42 PM

Is it running an AutoOpen macro that keeps the column widths the same every time the file is opened? This could have been set up so that the file looks the same every time...

Potential KFC eater · May 21st, 2002, 06:38 PM

Ted

Why the delay in responding to all these people providing the answers you have demanded?

You could at least say something instead of just passing on by.

When can we expect to see your posting of the pointers you mentioned?

In your expert opinion, does the eating of KFC products increase or decrease one's layability?

elgringo56 · May 21st, 2002, 06:45 PM

Oh, exaultant KFC eater. Thanks for putting a smile on this otherwise dismal face of mine. A good chuckle once in a while is worth more than learning how to get laid. NOT!!!

Ivan F Moala · May 21st, 2002, 07:18 PM

Ted if none of the above apply to your
situation (your problem that is) then I
suspect that you have a file that has been
converted from Lotus & that perhaps the one
of the BIFF (BInary File Format) indexes is
corrupted ??

Not to sure of a fix, but you could try
recreating your book(page from scratch !)

As I said I'm not 100% sure on this, but I have seen this before.

May 21st, 2002, 03:31 PM	#2
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Have you looked at Format, Columns, Set Width. __________________ Hope this helps! Rocky <h6>"Be not the first by whom the New are try'd, Nor yet the last to lay the Old aside." Alexander Pope (1688-1744).</h6>

May 21st, 2002, 07:18 PM	#10
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Ted if none of the above apply to your situation (your problem that is) then I suspect that you have a file that has been converted from Lotus & that perhaps the one of the BIFF (BInary File Format) indexes is corrupted ?? Not to sure of a fix, but you could try recreating your book(page from scratch !) As I said I'm not 100% sure on this, but I have seen this before. __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 03:07 PM	#1
Ted Wiebe New Member Join Date: May 2002 Posts: 5	I'm racking my brain. I have one Excel workbook that I've taken over from a former co-worker. Whenever I open this book, the column width is not the same as when I last saved it. For example I have 4 columns all 18 wide, but when I save , close and then re-open, the columns are back at 15.29. Any help would be appreciated Thanks

May 21st, 2002, 03:36 PM	#3
Ted Wiebe New Member Join Date: May 2002 Posts: 5	I've tried that, however, all other types of formatiing saves, except for when I change these column widths. I've got no Idea why.

May 21st, 2002, 04:12 PM	#4
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Ted, If it's really a problem, you could consider setting the column widths explicitly using the ColumnWidth property in VB. I know precisely no VB, but I'm sure someone out there would chip in with a bit of code... Paddy

May 21st, 2002, 04:20 PM	#5
SamS Board Regular Join Date: Feb 2002 Location: Brisbane, Down Under Posts: 533	have you looked at the worksheet module - right click on the worksheet tab and select view code - there is probably some vba code in there that is resetting the column width on you

May 21st, 2002, 04:26 PM	#6
jkpd2000 Board Regular Join Date: May 2002 Posts: 91	click above 1 , which will highlight the entire sheet. then in the menu select format,column, width then set to what ever width you want [ This Message was edited by: jkpd2000 on 2002-05-21 15:27 ]

May 21st, 2002, 05:42 PM	#7
WayneTN Board Regular Join Date: May 2002 Location: Tennessee, USA Posts: 72	Is it running an AutoOpen macro that keeps the column widths the same every time the file is opened? This could have been set up so that the file looks the same every time...

May 21st, 2002, 06:38 PM	#8
Potential KFC eater New Member Join Date: May 2002 Posts: 1	Ted Why the delay in responding to all these people providing the answers you have demanded? You could at least say something instead of just passing on by. When can we expect to see your posting of the pointers you mentioned? In your expert opinion, does the eating of KFC products increase or decrease one's layability?

May 21st, 2002, 06:45 PM	#9
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Oh, exaultant KFC eater. Thanks for putting a smile on this otherwise dismal face of mine. A good chuckle once in a while is worth more than learning how to get laid. NOT!!!