MS Excel Problem

Steve Mehs · 04-25-02, 06:10 PM

One day a few months ago out of the blue, when I was working on one of the channel or comparison charts for the DBSTalk homepage, I went to center some text. When I did I got the infamous illegal operation messege. Of coarse none of my changes were saved. Went back into excel, centered the text w/o a problem. Ever since that, everytime I goto center text in Excel I always get the illegal operation messege, but then when I go back into Excel it works fine. This has continued after completly uninastalling Office and reinstalling it and after 3 system restores. Any ideas, this has become a real pain in the butt and I use Excel for a lot more then just the DBSTalk pages. I have Corel Quatro Pro, but I dont have the time to learn it. I like WordPerfect and Presentations better then Word and PPT. Thanks!

MarkA · 04-25-02, 06:27 PM

Try reformatiing your hard drive, then reinstalling Excel. If that doesn't work, post back.

Steve Mehs · 04-25-02, 06:31 PM

One problem, remember I dont have a Windows CD, so an Fdisk would make my PC a door stop.

MarkA · 04-25-02, 06:35 PM

Why exactly don't you have a Windows CD?

Did you copy Windows from a friend? If so (or even if not), I'll tell you that Windows XP is well worth the $99 that an OEM Home full (not an upgrade that you need a CD for) will cost ya.

Steve Mehs · 04-25-02, 06:40 PM

No, it came with a system restore disk as most computers do now.

MarkA · 04-25-02, 06:52 PM

Yes, you run the system restore disk. Select the option (it should have one) to format the drive before restoring.

Steve Mehs · 04-25-02, 07:01 PM

When I do a system restore, all I do is pop the disc in, restart and away she goes, no options. But tried restores numerous times, and it didnt help

MarkA · 04-25-02, 07:18 PM

So you are reformating your drive (it wipes all your stuff, right?)? Weird. Please post the exact error message you get.

Steve Mehs · 04-25-02, 07:29 PM

The one time I try to get a program to crash it doesnt

Works fine now, it mysteriously came and now it looks like and I hope it mysteriosly went!

MarkA · 04-25-02, 07:56 PM

lol

Good luck Steve. If it crashes again post the error message and maybe I can help you out.

gcutler · 04-25-02, 11:29 PM

Steve,

Just like Windows has service packs, so does Office (thus Excel).

try http://office.microsoft.com/productupdates/

Then pick to detect what updates you may need.

At work I am in an infinite loop in that I had installed Office standard 2000 and then later installed Office Pro 2000 as we got the site license at that point. The Standard disappeared since Pro was bigger and better. But sometimes that update wants to update the Office Standard and wants the install CDs and all we have is the Office Pro :-{

But give it a try.

RichW · 04-27-02, 06:32 AM

"But sometimes that update wants to update the Office Standard and wants the install CDs and all we have is the Office Pro :-{ "

This can happen when you install Office on a system that already has Office. Try uninstalling office completely and then reinstalling Office Pro. Likewise the SR2 update for Office Pro used to give me some problems so I stayed with Office 2000 SR1.

I use Office XP now.

gcutler · 04-27-02, 07:37 PM

I remember that I wanted to uninstall Office Std, but the uninstall wanted the original install package to do the uninstall (which has been taken off the install server). So I just installed Office Pro on top of it (gotta get the job done). Well that has come back to kick me several times.

RichW · 04-28-02, 06:56 AM

You may be able to uninstall Office now without the CD or image for Office std. If you get a message everytime you start an office component (Word, Excel, etc.) an uninstall and reinstall should clear that up. You can also go in and muck with the registry keys if you are man enough.

(note the smilie)

gcutler · 04-28-02, 09:20 AM

Registry, Who's getting married???

Microsoft more than any other vendor will have so many little tie ins that removing Office Manually may require extra Testosterone shots before hand.

I just wish that MS's products were less a problem than anyone elses. I don't know of any other vendors (Lotus, Corel, etc) that make uninstalling such a pain in the ass.

Now you figure that some guy has an illegal copy and then decides to make everything legit and remove all the illegal SW. Good chance the guy will end up having to go the extra mile to get Office off the system.

But maybe MS wants to make it as big a pain for the legit user remove it???

At work we just removed Lotus Smart Suite from all the machines after a 1 year "Migration Period" from Lotus SS to MS Office. I'm much happier now. But they will have to pry Lotus Notes from my cold dead hands!!!