M
Marty
Hiyall:
I'm running Excel 2002 on XP Pro. I'm dealing with a
workbook wherein one of the worksheets will have about
3000 rows and around 50 columns. I'm trying to apply
validation (list of three possibilities from a list) and
conditional formatting (background color change depending
on which of the three possibilities is chosen) to 20 of
the 50 columns.
After I get about halfway through the formatting, when I
go to save the workbook, I get the following message box:
--------------------------------------------------
Excel could not save all the data and formatting you
recently added to {filename}.
- To return to your workbook without saving click Cancel.
- If you want to continue saving without repairing the
problem, click OK.
- For information about repairing the problem, click Help.
[three buttons: OK (default), Cancel, Help]
--------------------------------------------------
When I click help, the help screen comes up but it is
BLANK.
It acts almost as if there is a LIMIT on how much
validation and/or conditional formatting a worksheet can
tolerate. (I know about the 4000 distinct format limit:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;213904. This is not the problem. I'm nowhere near
that.)
I've tried staring over, same problem. Sounds like
Microsoft knows about the issue (hence the help button).
I just wish the help screen actually said something.
I would appreciate some advice.
Thanks,
MARTY
I'm running Excel 2002 on XP Pro. I'm dealing with a
workbook wherein one of the worksheets will have about
3000 rows and around 50 columns. I'm trying to apply
validation (list of three possibilities from a list) and
conditional formatting (background color change depending
on which of the three possibilities is chosen) to 20 of
the 50 columns.
After I get about halfway through the formatting, when I
go to save the workbook, I get the following message box:
--------------------------------------------------
Excel could not save all the data and formatting you
recently added to {filename}.
- To return to your workbook without saving click Cancel.
- If you want to continue saving without repairing the
problem, click OK.
- For information about repairing the problem, click Help.
[three buttons: OK (default), Cancel, Help]
--------------------------------------------------
When I click help, the help screen comes up but it is
BLANK.
It acts almost as if there is a LIMIT on how much
validation and/or conditional formatting a worksheet can
tolerate. (I know about the 4000 distinct format limit:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;213904. This is not the problem. I'm nowhere near
that.)
I've tried staring over, same problem. Sounds like
Microsoft knows about the issue (hence the help button).
I just wish the help screen actually said something.
I would appreciate some advice.
Thanks,
MARTY