LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 33
Default Getting a Strange Message from Excel

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.

Has anyone ever encountered this? Any ideas what handy
tips might be on that elusive help screen? Any REAL help
(not blank) will be appreciated.

Thanks,
MARTY


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange Message when opening workbook Jim Excel Discussion (Misc queries) 3 January 29th 09 04:15 PM
Strange message when Excel starts. vezerid Excel Discussion (Misc queries) 2 December 15th 06 01:03 PM
Strange message? Randy New Users to Excel 1 July 8th 05 08:21 PM
Strange Error Message Michael Windmeier Excel Discussion (Misc queries) 0 December 3rd 04 08:18 AM
Strange error message Jeroen Kluytmans Excel Programming 4 May 12th 04 12:33 PM


All times are GMT +1. The time now is 06:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"