Excel crashing

  oo7juk 13:08 18 May 07


I've been working on a spreadsheet at work and at home. The version I have at work is 2002 and the version I have at home is 2003. Last night I used conditional formatting on a column and saved. When i went to work I opened file and tried to enter data, but excel just crashed with the following message ' microsoft excel has encoutered a problem and needs to close' Is there anyway I can fix this. For info I can update spreadsheet ok at home.

Many thanks.

  VoG II 13:18 18 May 07

Try Detect and Repair on the Help menu.

  TonyV 13:19 18 May 07

Try opening Excel, then Help/Detect and Repair. Alternatively, sometimes it works if you switch off the machine, wait a couple of minutes and then switch back on again.


  TonyV 13:20 18 May 07

Oops! The man, VoG™, is too fast!


  oo7juk 13:31 18 May 07

Unfortunately, because I'm at work I don't have their installation disc. When I saved the file originally at home I saved the file type as microsoft excel workbook (default.) Someone mention that I should save doc as version 2002 and it should work, but it didn't. When I open the doc and the message pops up asking if I want to disable I click 'no' it lets me update, but the combo box won't work. If I click enable it just crashes. for info my security setting is set at medium.

Many thanks,

  VoG II 14:16 18 May 07
  skeletal 18:31 18 May 07

Something else to consider is that you may have things in your spreadsheet that are only supported by the 2003 version. Trying to operate them in 2002 can cause problems.


This thread is now locked and can not be replied to.

Nintendo Switch review: Hands on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Here's what should be coming to Adobe Project Felix in 2017

Apple AirPods review: Apple's beautiful new Bluetooth headphones bring true intelligence to…