Start-up Problem

A

AccessHelp

Hello,

Everyday when I first open Excel and when I type something in, it takes a
few seconds to show up in cell. After the first time, I don't have any delay.

Has anyone experienced it? Is there a setting in Excel that I need to change?

Thanks.
 
K

Kevin B

Do you have a Personal.xls file that is opening in the background. This file
contains macros that can be used by all workbooks. It opens when you start
Excel and is hidden from view. To view any hidden workbooks, click WINDOW in
the menu and select UNHIDE.

If UNHIDE is grayed out then this is not the issue.
 
A

AccessHelp

Kevin,

The Unhide is grayed out. I also checked the things that are running in the
background, and I didn't see "Personal.xls".

Thanks. What else could it be?
 
G

Gord Dibben

I would clean up up my TIF folder and any Temp folders as a starting point to
trouble-shooting.


Gord Dibben MS Excel MVP
 
A

AccessHelp

Thanks Gord. I clean my temp folders periodically and my Internet Temporary
Files folder daily.

Thanks.
 
G

Gord Dibben

No other guesses at this time.

Hang in......someone may come up with a tip.


Gord
 
A

AccessHelp

One more piece of information: I also did the "Detect and Repair" in Excel.

Thanks.
 
A

AccessHelp

Hi Dave,

Thanks for the information. I will try your instructions next day. My
problem is only happened one time a day. Even if I restart my computer now,
I do not have that problem. I am going to wait until tomorrow.

My problem is just like some human beings. You know you don't feel like
working at startup. Maybe, I will have to get a coffee to wake it up. Just
joking.

By the way, I clean the temp folders periodically and the Temporary Internet
Files folder daily.

If you think of others (besides coffee), please let me know.

Thanks. Have a nice weekend.
 
D

Dave Peterson

I think I had a car like that. It never liked starting on those bitter code
mornings. Oh, wait. That was me!

(I don't have anything else.)
 
A

AccessHelp

Good morning Dave,

I think I am not having the startup problem in Excel anymore, and I think I
know what fixes it.

Before I posted this tread, I had over 200MB of files in my Recycled Bin.
Then I deleted them all a couple of days ago. Since then, I have not had any
problem. That was unintentional fix.

That does not make sense. If you have cluttered with files in Recycled Bin,
Temp and TIF, Excel would cause problem. How could they be related to Excel?
Do you think that is the bug for Excel?

Anyway, thanks you and everyone for all the helps.

By the way, would you happen to know a discussion group or a site that I can
go to get help on writing a batch file?
 
D

Dave Peterson

I don't know of any problems that would be caused by files in the Recycle bin.
I've seen people post that the TIF could cause trouble, too--but I've never seen
that.

But too many files in the windows temp folder can cause trouble.

I don't know of any newsgroups that are dedicated to Batch files. But you may
find some web sites that still offer tips.

But there are lots of newsgroups dedicated to scripting (.bat files on
steroids???).

Here are some:

news://msnews.microsoft.com/microsoft.public.scripting.hosting
news://msnews.microsoft.com/microsoft.public.scripting.vbscript
news://msnews.microsoft.com/microsoft.public.scripting.wsh

and a couple of sites:
http://mvps.org/scripting/ (Alex Angelopoulos)
http://www.intranetjournal.com/corner/wrox/progref/vbt/index.html
http://groups.msn.com/windowsscript
http://www.winscripter.com/
http://www.billsway.com/vbspage/
http://ourworld.compuserve.com/homepages/Guenter_Born/WSHBazaar/wsh1.htm

Here's a batch file site:
http://members.cox.net/tglbatch/

(amazing what's in old bookmarks, huh?)

Good morning Dave,

I think I am not having the startup problem in Excel anymore, and I think I
know what fixes it.

Before I posted this tread, I had over 200MB of files in my Recycled Bin.
Then I deleted them all a couple of days ago. Since then, I have not had any
problem. That was unintentional fix.

That does not make sense. If you have cluttered with files in Recycled Bin,
Temp and TIF, Excel would cause problem. How could they be related to Excel?
Do you think that is the bug for Excel?

Anyway, thanks you and everyone for all the helps.

By the way, would you happen to know a discussion group or a site that I can
go to get help on writing a batch file?
Click to expand...
 
A

AccessHelp

Thanks Dave.

Dave Peterson said:
I don't know of any problems that would be caused by files in the Recycle bin.
I've seen people post that the TIF could cause trouble, too--but I've never seen
that.

But too many files in the windows temp folder can cause trouble.

I don't know of any newsgroups that are dedicated to Batch files. But you may
find some web sites that still offer tips.

But there are lots of newsgroups dedicated to scripting (.bat files on
steroids???).

Here are some:

news://msnews.microsoft.com/microsoft.public.scripting.hosting
news://msnews.microsoft.com/microsoft.public.scripting.vbscript
news://msnews.microsoft.com/microsoft.public.scripting.wsh

and a couple of sites:
http://mvps.org/scripting/ (Alex Angelopoulos)
http://www.intranetjournal.com/corner/wrox/progref/vbt/index.html
http://groups.msn.com/windowsscript
http://www.winscripter.com/
http://www.billsway.com/vbspage/
http://ourworld.compuserve.com/homepages/Guenter_Born/WSHBazaar/wsh1.htm

Here's a batch file site:
http://members.cox.net/tglbatch/

(amazing what's in old bookmarks, huh?)
Click to expand...
 
D

Dallman Ross

Dave Peterson said:
I don't know of any problems that would be caused by files in
the Recycle bin.
Click to expand...

I suggest the problem may have been that the system partition was
nearly full.
But too many files in the windows temp folder can cause trouble.

I don't know of any newsgroups that are dedicated to Batch files.
But you may find some web sites that still offer tips.
Click to expand...

Here's one I use about weekly that I made a while ago. It does
rely on the DOS executable "DELTREE", which is not standard with
Windows XP but which can be found in earlier Microsoft releases
and used just fine with XP as well. I put the DELTREE.EXE in
my command path before executing this batch file, which I named
"RM_TMP.BAT":

------------------ start cut here ------------------
@echo off

%SystemDrive%
cd %TEMP%

dir /l /od *tmp | find /i ".tmp"

del *.tmp > nul
deltree /y *.tmp > nul

pause
------------------ end cut here ------------------


No warranties, express or implied. :)

Here, I'll run it now; it's been a couple of days, anyway:

10/02/2006 11:06 AM 0 vga1.tmp
10/02/2006 12:43 PM 11,776 vb2f.tmp
10/02/2006 12:43 PM 11,776 vb30.tmp
10/02/2006 12:43 PM 16,384 32.tmp
10/02/2006 12:43 PM 262,144 ~df595e.tmp
10/02/2006 03:35 PM 1,855 tmp43.tmp
10/02/2006 03:35 PM 1,631 tmp44.tmp
10/02/2006 03:35 PM 56,319 tmp45.tmp
10/03/2006 11:40 AM 0 vga2.tmp
10/03/2006 11:52 AM 16,384 ~dffe56.tmp
[50 lines deleted]
10/05/2006 10:33 AM 32,768 ~df1d10.tmp
10/05/2006 10:33 AM 16,384 ~df24ba.tmp
10/05/2006 10:33 AM 262,144 ~dfbace.tmp
10/05/2006 10:33 AM 16,384 ~df2bd4.tmp
10/05/2006 10:33 AM 32,768 ~df3367.tmp
10/05/2006 10:33 AM 16,384 ~df493e.tmp
10/05/2006 10:33 AM 16,384 ~df4ecd.tmp
10/05/2006 12:35 PM 512 ~df391d.tmp
10/05/2006 03:02 PM 512 ~df6684.tmp
10/05/2006 03:05 PM 1,855 tmp19.tmp
10/05/2006 03:05 PM 1,631 tmp1a.tmp
10/05/2006 03:05 PM 56,319 tmp1b.tmp
10/05/2006 03:23 PM 32,768 ~df492d.tmp
10/05/2006 03:24 PM 32,768 ~df74c7.tmp
10/05/2006 03:24 PM 32,768 ~dfb0.tmp
10/05/2006 03:24 PM 32,768 ~df2a6f.tmp
10/05/2006 03:24 PM 32,768 ~df3209.tmp
Press any key to continue . . .

Dallman Ross
 
D

Dave Peterson

I have a shortcut on my desktop that points to a .vbs file that I run to clean
up my Temp folder.

http://groups.google.com/groups?threadm=#bXVsIHnAHA.920@tkmsftngp02

(By Michael Harris)

Dallman said:
Dave Peterson said:
I don't know of any problems that would be caused by files in
the Recycle bin.
Click to expand...

I suggest the problem may have been that the system partition was
nearly full.
But too many files in the windows temp folder can cause trouble.

I don't know of any newsgroups that are dedicated to Batch files.
But you may find some web sites that still offer tips.
Click to expand...

Here's one I use about weekly that I made a while ago. It does
rely on the DOS executable "DELTREE", which is not standard with
Windows XP but which can be found in earlier Microsoft releases
and used just fine with XP as well. I put the DELTREE.EXE in
my command path before executing this batch file, which I named
"RM_TMP.BAT":

------------------ start cut here ------------------
@echo off

%SystemDrive%
cd %TEMP%

dir /l /od *tmp | find /i ".tmp"

del *.tmp > nul
deltree /y *.tmp > nul

pause
------------------ end cut here ------------------

No warranties, express or implied. :)

Here, I'll run it now; it's been a couple of days, anyway:

10/02/2006 11:06 AM 0 vga1.tmp
10/02/2006 12:43 PM 11,776 vb2f.tmp
10/02/2006 12:43 PM 11,776 vb30.tmp
10/02/2006 12:43 PM 16,384 32.tmp
10/02/2006 12:43 PM 262,144 ~df595e.tmp
10/02/2006 03:35 PM 1,855 tmp43.tmp
10/02/2006 03:35 PM 1,631 tmp44.tmp
10/02/2006 03:35 PM 56,319 tmp45.tmp
10/03/2006 11:40 AM 0 vga2.tmp
10/03/2006 11:52 AM 16,384 ~dffe56.tmp
[50 lines deleted]
10/05/2006 10:33 AM 32,768 ~df1d10.tmp
10/05/2006 10:33 AM 16,384 ~df24ba.tmp
10/05/2006 10:33 AM 262,144 ~dfbace.tmp
10/05/2006 10:33 AM 16,384 ~df2bd4.tmp
10/05/2006 10:33 AM 32,768 ~df3367.tmp
10/05/2006 10:33 AM 16,384 ~df493e.tmp
10/05/2006 10:33 AM 16,384 ~df4ecd.tmp
10/05/2006 12:35 PM 512 ~df391d.tmp
10/05/2006 03:02 PM 512 ~df6684.tmp
10/05/2006 03:05 PM 1,855 tmp19.tmp
10/05/2006 03:05 PM 1,631 tmp1a.tmp
10/05/2006 03:05 PM 56,319 tmp1b.tmp
10/05/2006 03:23 PM 32,768 ~df492d.tmp
10/05/2006 03:24 PM 32,768 ~df74c7.tmp
10/05/2006 03:24 PM 32,768 ~dfb0.tmp
10/05/2006 03:24 PM 32,768 ~df2a6f.tmp
10/05/2006 03:24 PM 32,768 ~df3209.tmp
Press any key to continue . . .

Dallman Ross
Click to expand...
 
Top