I have a large Excel 2000 workbook that won't open because it has "Too many
different cell formats." My solution is to somehow get in and delete all the
borders on the one non-hidden worksheet to try to get rid of a few hundred
cell formats. Is it possible to stop the error message and delete the
borders or cell shading before the error occurs?

I have already gone to a website that supposedly sells software that will do
this for 100 british pounds. There has got to be an easier way.

Thanks in advance,
Tim

A few people have posted that they could open the file in OpenOffice, then
remove some of the formatting, save it and then excel would open that file ok.

http://www.openoffice.org, a 60-65 meg download or a CD

timlow wrote:

I have a large Excel 2000 workbook that won't open because it has "Too many
different cell formats." My solution is to somehow get in and delete all the
borders on the one non-hidden worksheet to try to get rid of a few hundred
cell formats. Is it possible to stop the error message and delete the
borders or cell shading before the error occurs?

I have already gone to a website that supposedly sells software that will do
this for 100 british pounds. There has got to be an easier way.

Thanks in advance,
Tim

--

Dave Peterson

Thanks. Good to know. I'll try it.

Tim

"Dave Peterson" wrote:

A few people have posted that they could open the file in OpenOffice, then
remove some of the formatting, save it and then excel would open that file ok.

http://www.openoffice.org, a 60-65 meg download or a CD

timlow wrote:

I have a large Excel 2000 workbook that won't open because it has "Too many
different cell formats." My solution is to somehow get in and delete all the
borders on the one non-hidden worksheet to try to get rid of a few hundred
cell formats. Is it possible to stop the error message and delete the
borders or cell shading before the error occurs?

I have already gone to a website that supposedly sells software that will do
this for 100 british pounds. There has got to be an easier way.

Thanks in advance,
Tim

--

Dave Peterson

Dave,

My IT department wouldn't allow downloading Open Office. But, I opened the
file in Office 2003 and it repaired it automatically. It made it a mess
because it erased ALL the formatting and macros, but all the important data
was there. This saved dozens of manhours!! Thanks.

Tim

"Dave Peterson" wrote:

A few people have posted that they could open the file in OpenOffice, then
remove some of the formatting, save it and then excel would open that file ok.

http://www.openoffice.org, a 60-65 meg download or a CD

timlow wrote:

I have a large Excel 2000 workbook that won't open because it has "Too many
different cell formats." My solution is to somehow get in and delete all the
borders on the one non-hidden worksheet to try to get rid of a few hundred
cell formats. Is it possible to stop the error message and delete the
borders or cell shading before the error occurs?

I have already gone to a website that supposedly sells software that will do
this for 100 british pounds. There has got to be an easier way.

Thanks in advance,
Tim

--

Dave Peterson

And plain vanilla is very nice!

timlow wrote:

Dave,

My IT department wouldn't allow downloading Open Office. But, I opened the
file in Office 2003 and it repaired it automatically. It made it a mess
because it erased ALL the formatting and macros, but all the important data
was there. This saved dozens of manhours!! Thanks.

Tim

"Dave Peterson" wrote:

A few people have posted that they could open the file in OpenOffice, then
remove some of the formatting, save it and then excel would open that file ok.

http://www.openoffice.org, a 60-65 meg download or a CD

timlow wrote:

I have a large Excel 2000 workbook that won't open because it has "Too many
different cell formats." My solution is to somehow get in and delete all the
borders on the one non-hidden worksheet to try to get rid of a few hundred
cell formats. Is it possible to stop the error message and delete the
borders or cell shading before the error occurs?

I have already gone to a website that supposedly sells software that will do
this for 100 british pounds. There has got to be an easier way.

Thanks in advance,
Tim

--

Dave Peterson


--

Dave Peterson