I have plenty of workbooks created in Excel 97. My company just upgraded all
the office computers to Excel 2002. The workbooks with formulas created in
97 will not print in 2002. Some of them have this error-correcting thing
that comes up pertaining to conditional formats. And then repairs them by
clearing the format out. But still will not print. Can you folks guide me to
some information explaining this and hopefully a workaround? Thank you

More information is required, as this is normally not a problem.

Jerry

Shorty wrote:

> I have plenty of workbooks created in Excel 97. My company just upgraded all
> the office computers to Excel 2002. The workbooks with formulas created in
> 97 will not print in 2002. Some of them have this error-correcting thing
> that comes up pertaining to conditional formats. And then repairs them by
> clearing the format out. But still will not print. Can you folks guide me to
> some information explaining this and hopefully a workaround? Thank you

Shorty,

Say more about this "error-correcting thing that comes up pertaining to
conditional formats." You say they "won't print." What does that mean?
Blank pages of paper? Error message?

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Shorty" <(E-Mail Removed)> wrote in message
news:e%qwd.43447$(E-Mail Removed)...
>I have plenty of workbooks created in Excel 97. My company just upgraded
>all the office computers to Excel 2002. The workbooks with formulas created
>in 97 will not print in 2002. Some of them have this error-correcting thing
>that comes up pertaining to conditional formats. And then repairs them by
>clearing the format out. But still will not print. Can you folks guide me
>to some information explaining this and hopefully a workaround? Thank you
>
>

When you got to Print an error box comes up asking if I want to send the
error report to Microsoft. And in the middle of the box is a check box to
automatically have Excel correct the error. Were on a private intranet so we
cannot send the error report out to Microsoft. Then excel gives a choice of
repaired files to chose from. You can view the errors, (and it always say
something about conditional formatting) save as, or delete. Neither of these
options does any good cause when you go to print the file it all starts over
again with no results.

Shorty


"Earl Kiosterud" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Shorty,
>
> Say more about this "error-correcting thing that comes up pertaining to
> conditional formats." You say they "won't print." What does that mean?
> Blank pages of paper? Error message?
>
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "Shorty" <(E-Mail Removed)> wrote in message
> news:e%qwd.43447$(E-Mail Removed)...
>>I have plenty of workbooks created in Excel 97. My company just upgraded
>>all the office computers to Excel 2002. The workbooks with formulas
>>created in 97 will not print in 2002. Some of them have this
>>error-correcting thing that comes up pertaining to conditional formats.
>>And then repairs them by clearing the format out. But still will not
>>print. Can you folks guide me to some information explaining this and
>>hopefully a workaround? Thank you
>>
>>
>
>
>