An error occured and this feature is no longer functioning properly. help!

L

Lana

This is what I get when saving my workbook. also it offers install some
soft to repair the "feature". A runtime error happens when installing.

I don't understand what feature is it about.
Before that I made a copy of this book in csv format (when saving as
csv, I also got a message that some features will not be compatible
with csv format and I agreed because I guessed it was about a command
button in the worksheet). When I opened xls book next time and tried to
save it, it gave me the subj message, but saved after all in the end. I
wonder if it is likely to cause me problems in the future.
 
D

Dave Peterson

CSV files are plain text. So you won't be able to save more than one
worksheet's data. You won't be able to save formulas, columnwidths, rowheights,
all the formatting--all that stuff that makes stuff look pretty.

If you open the .xls file, then you must have saved that before you saved the
copy as .csv. (Use notepad to open that .csv and you'll see just plain old
text.)

Why you get the runtime error, I don't have a guess. CSV files by themselves
won't do this.

Well, actually a few xl crashes are caused by a corrupt toolbar file
(*.xlb--name and location vary with versions of windows and excel).

If you try opening xl in safe mode:
close excel (if you have it open)
windows start button|Run
excel /safe

Did it work ok?

If yes:

close excel
windows start button|find/search for *.xlb

rename them to *.xlbOLD
and try it normally again. If it worked ok, then dump those *.xlbOLD files
and recreate your toolbars at your leisure.

If it didn't help, rename them back to *.xlb and see if there's something else
that's causing the trouble.

Maybe there's a workbook/addin that's causing the trouble.

You can use some techniques that Chip Pearson shares on his web site:
http://www.cpearson.com/excel/StartupErrors.htm

Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)

Then one by one, you'll add one back and restart excel to see if that caused the
problem.

If none of this worked, if you're using xl2k+, there's an option under Help
called Detect and Repair. Maybe that would find & fix the problem.
 
Top