I've been getting fatal errors in XL2000 a lot lately. I looked around
here to see if I could find some info on the problem. I found a thread
saying that "controls" can cause XL lockups. Does this mean macro
buttons? In my case, macro buttons are just buttons I create from the
"Forms" toolbar, rename and assign a macro to. Do they cause XL
lockups?
I downloaded a program called "CodeCleaner" but it didn't install,
apparently. When I tried to run it per the instructions at the end of
the install, the command to run it doesn't appear on my "Tools,
Options" menu as it's supposed to. It's there and checked in the
"Add-ins" menu, but not anywhere I can access it. Tried from both the
spreadsheet and the VBE editor.
Is this the most likely source of my problem? If so, what can I do
about it? If not, what is the most likely source and what can you
reccommend about that?
BTW, I don't think it's memory related. I have 1G of memory. I do,
however, run a lot of stuff normally, including the 2M XL file I'm
usually working on and maybe one or two others, Novell GroupWise, my
browser, and often a file folder or 2 and possibly a Word documemt. I
added it all up from the Task Manager and show just over 200M.
Thanks in advance.

close excel.

clean your temp directory...

windows/start/run %temp%
will get you there.

1000 files?.. or more?

delete everything (files and folders)!
1 or 2 files cannot be deleted because there 'in use'
the rest should go.

now keep watching that dir when you start excel,
and open your favourite 'shape-rich' workbook..

see why I dont like embedded controls?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


davegb wrote :

I've been getting fatal errors in XL2000 a lot lately. I looked around
here to see if I could find some info on the problem. I found a thread
saying that "controls" can cause XL lockups. Does this mean macro
buttons? In my case, macro buttons are just buttons I create from the
"Forms" toolbar, rename and assign a macro to. Do they cause XL
lockups?
I downloaded a program called "CodeCleaner" but it didn't install,
apparently. When I tried to run it per the instructions at the end of
the install, the command to run it doesn't appear on my "Tools,
Options" menu as it's supposed to. It's there and checked in the
"Add-ins" menu, but not anywhere I can access it. Tried from both the
spreadsheet and the VBE editor.
Is this the most likely source of my problem? If so, what can I do
about it? If not, what is the most likely source and what can you
reccommend about that?
BTW, I don't think it's memory related. I have 1G of memory. I do,
however, run a lot of stuff normally, including the 2M XL file I'm
usually working on and maybe one or two others, Novell GroupWise, my
browser, and often a file folder or 2 and possibly a Word documemt. I
added it all up from the Task Manager and show just over 200M.
Thanks in advance.

keepITcool wrote:
close excel.

clean your temp directory...

windows/start/run %temp%
will get you there.

1000 files?.. or more?

delete everything (files and folders)!
1 or 2 files cannot be deleted because there 'in use'
the rest should go.

now keep watching that dir when you start excel,
and open your favourite 'shape-rich' workbook..

see why I dont like embedded controls?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


davegb wrote :

I've been getting fatal errors in XL2000 a lot lately. I looked around
here to see if I could find some info on the problem. I found a thread
saying that "controls" can cause XL lockups. Does this mean macro
buttons? In my case, macro buttons are just buttons I create from the
"Forms" toolbar, rename and assign a macro to. Do they cause XL
lockups?
I downloaded a program called "CodeCleaner" but it didn't install,
apparently. When I tried to run it per the instructions at the end of
the install, the command to run it doesn't appear on my "Tools,
Options" menu as it's supposed to. It's there and checked in the
"Add-ins" menu, but not anywhere I can access it. Tried from both the
spreadsheet and the VBE editor.
Is this the most likely source of my problem? If so, what can I do
about it? If not, what is the most likely source and what can you
reccommend about that?
BTW, I don't think it's memory related. I have 1G of memory. I do,
however, run a lot of stuff normally, including the 2M XL file I'm
usually working on and maybe one or two others, Novell GroupWise, my
browser, and often a file folder or 2 and possibly a Word documemt. I
added it all up from the Task Manager and show just over 200M.
Thanks in advance.

Thanks for the help. I deleted everything it would let me delete. There
were about 60 items including folders. 6 it would not let me delete.

Why do embedded controls cause this problem? Is MS planning on fixing
this or is it just not common enough for them to worry about (I imagine
less than 1% of users use embedded controls)? What are the alternatives
to embedded controls for very basic end users (many of them think
adjusting column widths is advanced XL!)?

davegb wrote:
keepITcool wrote:
close excel.

clean your temp directory...

windows/start/run %temp%
will get you there.

1000 files?.. or more?

delete everything (files and folders)!
1 or 2 files cannot be deleted because there 'in use'
the rest should go.

now keep watching that dir when you start excel,
and open your favourite 'shape-rich' workbook..

see why I dont like embedded controls?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


davegb wrote :

I've been getting fatal errors in XL2000 a lot lately. I looked around
here to see if I could find some info on the problem. I found a thread
saying that "controls" can cause XL lockups. Does this mean macro
buttons? In my case, macro buttons are just buttons I create from the
"Forms" toolbar, rename and assign a macro to. Do they cause XL
lockups?
I downloaded a program called "CodeCleaner" but it didn't install,
apparently. When I tried to run it per the instructions at the end of
the install, the command to run it doesn't appear on my "Tools,
Options" menu as it's supposed to. It's there and checked in the
"Add-ins" menu, but not anywhere I can access it. Tried from both the
spreadsheet and the VBE editor.
Is this the most likely source of my problem? If so, what can I do
about it? If not, what is the most likely source and what can you
reccommend about that?
BTW, I don't think it's memory related. I have 1G of memory. I do,
however, run a lot of stuff normally, including the 2M XL file I'm
usually working on and maybe one or two others, Novell GroupWise, my
browser, and often a file folder or 2 and possibly a Word documemt. I
added it all up from the Task Manager and show just over 200M.
Thanks in advance.

Thanks for the help. I deleted everything it would let me delete. There
were about 60 items including folders. 6 it would not let me delete.

Why do embedded controls cause this problem? Is MS planning on fixing
this or is it just not common enough for them to worry about (I imagine
less than 1% of users use embedded controls)? What are the alternatives
to embedded controls for very basic end users (many of them think
adjusting column widths is advanced XL!)?

Following up on my previous message. BE CAREFUL DELETING FILES FROM
YOUR TEMP FOLDER! I was advised to delete everything in the Temp
directory in this NG, and my Novell Groupwise email client couldn't
reply to incoming emails until I went back and restored some files it
keeps in the Temp directory! I don't yet know if other programs use the
Temp directory, but I'll be watching for them. I'm trying to find out
which ones it's safe to delete.

Lots of people recommend doing this clean up right after you boot up (so there's
no applications running) or right before you shut down (after you've closed all
applications).



davegb wrote:

davegb wrote:
keepITcool wrote:
close excel.

clean your temp directory...

windows/start/run %temp%
will get you there.

1000 files?.. or more?

delete everything (files and folders)!
1 or 2 files cannot be deleted because there 'in use'
the rest should go.

now keep watching that dir when you start excel,
and open your favourite 'shape-rich' workbook..

see why I dont like embedded controls?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


davegb wrote :

I've been getting fatal errors in XL2000 a lot lately. I looked around
here to see if I could find some info on the problem. I found a thread
saying that "controls" can cause XL lockups. Does this mean macro
buttons? In my case, macro buttons are just buttons I create from the
"Forms" toolbar, rename and assign a macro to. Do they cause XL
lockups?
I downloaded a program called "CodeCleaner" but it didn't install,
apparently. When I tried to run it per the instructions at the end of
the install, the command to run it doesn't appear on my "Tools,
Options" menu as it's supposed to. It's there and checked in the
"Add-ins" menu, but not anywhere I can access it. Tried from both the
spreadsheet and the VBE editor.
Is this the most likely source of my problem? If so, what can I do
about it? If not, what is the most likely source and what can you
reccommend about that?
BTW, I don't think it's memory related. I have 1G of memory. I do,
however, run a lot of stuff normally, including the 2M XL file I'm
usually working on and maybe one or two others, Novell GroupWise, my
browser, and often a file folder or 2 and possibly a Word documemt. I
added it all up from the Task Manager and show just over 200M.
Thanks in advance.

Thanks for the help. I deleted everything it would let me delete. There
were about 60 items including folders. 6 it would not let me delete.

Why do embedded controls cause this problem? Is MS planning on fixing
this or is it just not common enough for them to worry about (I imagine
less than 1% of users use embedded controls)? What are the alternatives
to embedded controls for very basic end users (many of them think
adjusting column widths is advanced XL!)?

Following up on my previous message. BE CAREFUL DELETING FILES FROM
YOUR TEMP FOLDER! I was advised to delete everything in the Temp
directory in this NG, and my Novell Groupwise email client couldn't
reply to incoming emails until I went back and restored some files it
keeps in the Temp directory! I don't yet know if other programs use the
Temp directory, but I'll be watching for them. I'm trying to find out
which ones it's safe to delete.

--

Dave Peterson

Dave Peterson wrote:
Lots of people recommend doing this clean up right after you boot up (so there's
no applications running) or right before you shut down (after you've closed all
applications).



davegb wrote:

davegb wrote:
keepITcool wrote:
close excel.

clean your temp directory...

windows/start/run %temp%
will get you there.

1000 files?.. or more?

delete everything (files and folders)!
1 or 2 files cannot be deleted because there 'in use'
the rest should go.

now keep watching that dir when you start excel,
and open your favourite 'shape-rich' workbook..

see why I dont like embedded controls?


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


davegb wrote :

I've been getting fatal errors in XL2000 a lot lately. I looked around
here to see if I could find some info on the problem. I found a thread
saying that "controls" can cause XL lockups. Does this mean macro
buttons? In my case, macro buttons are just buttons I create from the
"Forms" toolbar, rename and assign a macro to. Do they cause XL
lockups?
I downloaded a program called "CodeCleaner" but it didn't install,
apparently. When I tried to run it per the instructions at the end of
the install, the command to run it doesn't appear on my "Tools,
Options" menu as it's supposed to. It's there and checked in the
"Add-ins" menu, but not anywhere I can access it. Tried from both the
spreadsheet and the VBE editor.
Is this the most likely source of my problem? If so, what can I do
about it? If not, what is the most likely source and what can you
reccommend about that?
BTW, I don't think it's memory related. I have 1G of memory. I do,
however, run a lot of stuff normally, including the 2M XL file I'm
usually working on and maybe one or two others, Novell GroupWise, my
browser, and often a file folder or 2 and possibly a Word documemt. I
added it all up from the Task Manager and show just over 200M.
Thanks in advance.

Thanks for the help. I deleted everything it would let me delete. There
were about 60 items including folders. 6 it would not let me delete.

Why do embedded controls cause this problem? Is MS planning on fixing
this or is it just not common enough for them to worry about (I imagine
less than 1% of users use embedded controls)? What are the alternatives
to embedded controls for very basic end users (many of them think
adjusting column widths is advanced XL!)?

Following up on my previous message. BE CAREFUL DELETING FILES FROM
YOUR TEMP FOLDER! I was advised to delete everything in the Temp
directory in this NG, and my Novell Groupwise email client couldn't
reply to incoming emails until I went back and restored some files it
keeps in the Temp directory! I don't yet know if other programs use the
Temp directory, but I'll be watching for them. I'm trying to find out
which ones it's safe to delete.

--

Dave Peterson

I'm not too sure this fix is working. XL locked up on me yesterday
afternoon, not long after I cleaned out my Temp file. Will keep working
on it....