Excel 2000 crashes when trying to print or print preview

The problem lies not in Excel, the problem is most likely your printer driver. Make sure the most current printer driver is loaded, and that may not be the one that came with windows--you may need to get it from the printer mfr website.

I'm sure your IT guy had his reasons...

If changing the printer driver don't work (Try both PS and PCL drivers), then goto

http://office.microsoft.com/ProductUpdates/

And get the latest Patches for Office and Excel.

If that still dont work, I know it sound funny, BUT defrag your HDD.  If you are using W2k or WXP change the swap file (Virtual Memory) to double that of your RAM, eg if your RAM is 128mb then make the swap file 256mb or move it to a different drive.

If that still fails to work, yourself or a teckie might need to check the processor fan is still running (system maybe overheating) or change the RAM in your machine, It might be faulty.

Thanks!

The problem also happens with those files on other PC's. So, as per Lord Lethris's suggestion I tried to cut and paste the data from one problem Excel into a new document and that worked perfectly!  Before, LL, I was just doing the "save as" file thing, which as you pointed out, didn't work. Should I still download the updated drivers just to be safe?

No Problem

Oh yea.... sorry well away with myself! LOL  er.. yea... if it now works, why fix it? ;)... don't bother with the drivers, BUT I do strongly suggest installing the Office updates from the Previous link I sent.  As all techies know, Excel is a produced that is never quite finished and full of bugs when released for sale!!! :D

you know, you're right!  Where is that perfect version promised from Microsoft, huh?  The sad thing is that I have to do this with all my pertinent Excel files. Could this happened in the process of copying or burning the files on to a CD before our IT guy reformated my computer?

Thanks again for all your help!

There could have been a number of issues that could have caused this....:-

Read only attributes messing up when copying over from CD-ROM.

Excel may have been patched on your Previous install and the files belong to a higher Service Patch, so saving them on a non patched machine may have caused an issue.

Excel decided one day to be bastard by Royal Appointment.

The list is endless.  The main focus is that the problem is solved, even if it is a little bit time consuming.

;)

Here Here!

Thanks so much for your help LL!

Cheers

No Problem

New problem!
Downloaded from Microsoft Office Product updates as you suggested LL. The product I downloaded was Office 2000 Service Release 1a (SR-1a). Now everytime I try to open an Office program like Word, Excel and Outlook the program closes after a couple seconds!  Is there anyway to go about fixing this situation?

Thanks

hang on just looking

tisk tisk

http://support.microsoft.com/default.aspx?scid=kb;en-us;255503

looks like your techies are using eather a beta or a cracked copy of office 2000.

Sorry.

Think you are right.  Will bring this up with my supervisor.  Thanks again!

No Problem.

You could try removing SR1a.  I have procedures for stripping a PC of office, even all the hidden stuff that don't get removed when un-installing office.

I think that is the route I have to take, Stripping SR1a.
Appreciate knowing how you go about it.  Major concern is saving email through Outlook for the past week or so.
Thanks!

I said I'd get back and I have.

1st you need to uninstall office.

Then you need to get the program called eraser2k.exe, you can get it here -

http://download.microsoft.com/download/office2000pro/Update/3.1/WIN98Me/EN-US/eraser2k.exe

When you run that file, it will extract the utility.  You then need to run the Eraser2000.exe file and it should do the rest.

You can if you wish manually run this utility with more control by running the Offcln9.exe file also included with this utility with the following switches

Switch       Description         Example
   -------------------------------------------------------
         
   /a        Aggressive mode.    Offcln9.exe /a
   /L        Create Log file.    Offcln9.exe /Lofflog.txt
   /L!       Log only. Do not    Offcln9.exe /L!offlog.txt
             delete anything.
   /q        Quiet mode.         Offcln9.exe /q
   /r        Restart system.     Offcln9.exe /a /q /r
   /s        Safe mode.          Offcln9.exe /s

So to do a secure and total removal logged and without prompt and self reboot, type at a command prompt :-

Offcln9.exe /a /Lremoved.txt /q /r

and your computer will never know office had ever been installed.

You may have to re-install some programs that use any of the office shared program files like "ACT!" or "SQL", but as you are going to re-install ofice anyway, that doesn't matter too much in your case.

One other note... this tool, according to microsoft, hasn't been tested with Windows XP, and to be used at your own discression under that operating system.

hope that helps! :)