LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
No Name
 
Posts: n/a
Default Conditional formatting causing Excel to crash

Hi - and thanks for reading this.

I have a csv file which I open in Excel (2K). It is 4 columns by about 300
rows. When I conditional format a row (something simple like =$D2=$D1) and
try to save the sheet as XLS, it crashes. I can save it as long as I don't
change the format (Font, Pattern or Border). I've tried it on two machines.
On one it just closes Excel without warning or error, and on the other it
crashed with an error dialog box.

I don't understand why it does this. I have been using Excel for years
without problems. Could it be something in the csv that is causing it? If I
load the csv, save it as an XLS and then try and CF, it still crashes.

Thanks.
Andy.


 
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
* causing problems with finding duplicates with conditional format Michele - DARCC Excel Discussion (Misc queries) 1 March 26th 08 02:49 PM
Why does Excel 2000 crash when formatting a cell to Date? J.Vey Excel Discussion (Misc queries) 2 September 22nd 06 07:58 PM
Macro Glitch Causing Crash Danimagus Excel Discussion (Misc queries) 1 June 6th 05 06:19 PM
conditional forming causing linking errors Dave Breitenbach Excel Worksheet Functions 0 April 1st 05 08:19 PM
Charts causing program to crash Fysh Charts and Charting in Excel 1 December 16th 04 10:12 PM


All times are GMT +1. The time now is 08:12 PM.

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"