Making a chart in excel.

[blackcat]

Whenever I try to make a chart from data in excel, it returns " The program
has enountered an error and will shut itself down down" and then it does. How
can I make a chart?
--
bill

[Tushar Mehta]

In article <[email protected]>,
[email protected] says...
> Whenever I try to make a chart from data in excel, it returns " The program
> has enountered an error and will shut itself down down" and then it does. How
> can I make a chart?
>
About the best I can suggest is to do more diagostics or repair. And,
keep in mind that it is your machine. Don't do something you don't
feel comfortable with since you accept responsibility if any of the
below causes further problems.

You may just want to skip to the last step. It will take the longest
but requires the least amount of work on your part.

Does the problem occur with only a particular file? If so, that file
may be on the verge of corruption. Copy the data to another file.
Depending on how complicated this file architecture is the process may
be trivial to very difficult.

Do you have any add-ins? If so, disable them. Do you have anything in
your personal.xls file? If so, move that file temporarily to another
folder. Do the same with other files in the start up and alternative
start up folders. If this works, you can identify the cause of the
problem.

If this still doesn't work, unregister and re-register XL. Run XL from
the Windows command line with "c:\{full path name to *your* copy of}
\excel.exe /unregserver and then run XL again this time with /regserver

If that still doesn't work, delete the .xlb file (you will have to use
Windows Search to find it). Note that this will delete any
customization you did to your toolbars, etc.

If this still doesn't work, repair the software. Note that this may
require you to use your Office installation CD/DVD. If you don't have
it/them, do *not* start this process. Run XL and select Help | Detect
and Repair...If even this doesn't work, uninstall XL / Office and
reinstall it.

Or, it might be something trivial that I've overlooked and someone else
will point out... {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

[blackcat]

Thanks for the info. I will try some of the instructions. I have already
tried the repair part, but at the end of the repair, it still does the same
thing with all files. Coincidently, the pesky help assistant also disappeared
for unknown reasons some time ago and whenever I try to call on the
assistant, the program shouts down with the message "This program has
encountered an error and wille shut down"
--
bill


"Tushar Mehta" wrote:

> In article <[email protected]>,
> [email protected] says...
> > Whenever I try to make a chart from data in excel, it returns " The program
> > has enountered an error and will shut itself down down" and then it does. How
> > can I make a chart?
> >
> About the best I can suggest is to do more diagostics or repair. And,
> keep in mind that it is your machine. Don't do something you don't
> feel comfortable with since you accept responsibility if any of the
> below causes further problems.
>
> You may just want to skip to the last step. It will take the longest
> but requires the least amount of work on your part.
>
> Does the problem occur with only a particular file? If so, that file
> may be on the verge of corruption. Copy the data to another file.
> Depending on how complicated this file architecture is the process may
> be trivial to very difficult.
>
> Do you have any add-ins? If so, disable them. Do you have anything in
> your personal.xls file? If so, move that file temporarily to another
> folder. Do the same with other files in the start up and alternative
> start up folders. If this works, you can identify the cause of the
> problem.
>
> If this still doesn't work, unregister and re-register XL. Run XL from
> the Windows command line with "c:\{full path name to *your* copy of}
> \excel.exe /unregserver and then run XL again this time with /regserver
>
> If that still doesn't work, delete the .xlb file (you will have to use
> Windows Search to find it). Note that this will delete any
> customization you did to your toolbars, etc.
>
> If this still doesn't work, repair the software. Note that this may
> require you to use your Office installation CD/DVD. If you don't have
> it/them, do *not* start this process. Run XL and select Help | Detect
> and Repair...If even this doesn't work, uninstall XL / Office and
> reinstall it.
>
> Or, it might be something trivial that I've overlooked and someone else
> will point out... {grin}
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>