Troubleshoot Excel 2002 formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TopDog - 27 Nov 2006 23:37 GMT

I have a rather large spreadsheet using nearly all columns. It has many rows
of data with text headings at the top of the data columns. (There are just a
few rows above that for "report title" types of content.)

Along the way, somehow Excel lost track of the formatting. Starting around
column DV and to the right of that, the heading text is not displaying. You
can see in the middle of some columns where text is being overlaid over the
real content.

Anyone know what causes this Excel problem and how to fix it?

Reply to this Message

TopDog - 29 Nov 2006 06:02 GMT

Hint: When attempting to copy the sheet to another workbook, a warning
message from Excel indicated some cells containing more than 255 characters.
It could be related to the length of the text in my headings. I have been
using headings that explain the complex formula propagated down the rows of
each column. (I really don't know which cell. It could be one of those
lengthy-text headings or it could be a formula. That's because the formulas
are so complex that I've been using defined names feature to give all the
formula arguments more human meaning, which names result in a lot of
characters to express the formula.)

> I have a rather large spreadsheet using nearly all columns. It has many rows
> of data with text headings at the top of the data columns. (There are just a
[quoted text clipped - 6 lines]
>
> Anyone know what causes this Excel problem and how to fix it?

Reply to this Message