ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Long time to load (https://www.excelbanter.com/excel-programming/285352-long-time-load.html)

john

Long time to load
 
It take forever to load a worksheet (3-4 minutes). I
have a new, powerful machine. If I load the file on
someone else's computer it takes one second to load.
I've turned off my virus protection software, disabled
macros, and I'm at a loss at to why it takes so long to
load. Any suggestions? Thanks, John

Chip Pearson

Long time to load
 
John,

Clear out (delete) the files from your temp directory(s).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"john" wrote in message
...
It take forever to load a worksheet (3-4 minutes). I
have a new, powerful machine. If I load the file on
someone else's computer it takes one second to load.
I've turned off my virus protection software, disabled
macros, and I'm at a loss at to why it takes so long to
load. Any suggestions? Thanks, John




Tom Ogilvy

Long time to load
 
Do you have virus protection that is checking the file (such as Norton
Anti-Virus).

Also, with Excel closed, try cleaning out your Temp folder.

--
Regards,
Tom Ogilvy

john wrote in message
...
It take forever to load a worksheet (3-4 minutes). I
have a new, powerful machine. If I load the file on
someone else's computer it takes one second to load.
I've turned off my virus protection software, disabled
macros, and I'm at a loss at to why it takes so long to
load. Any suggestions? Thanks, John




john

Long time to load
 
Thanks, when I loaded the software I used the default
settings for the directory structure. I couldn't find
a 'temp' directory. Any suggestions on where to look?

Thanks for your help. John


-----Original Message-----
John,

Clear out (delete) the files from your temp directory(s).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"john" wrote in message
...
It take forever to load a worksheet (3-4 minutes). I
have a new, powerful machine. If I load the file on
someone else's computer it takes one second to load.
I've turned off my virus protection software, disabled
macros, and I'm at a loss at to why it takes so long to
load. Any suggestions? Thanks, John



.


Dave Peterson[_3_]

Long time to load
 
This is the windows temp folder--not exclusive to excel.

Windows Start button
Run
%temp%
(both percent signs are needed)
Hit ok.

(it's the quickest way I know to get there.)

Depending on what's running, you might get some "can't delete" warnings. Just
select your files around those.

When I do it by hand, I show the list in detail view and sort by date. Then I
can get rid of everything before today in one fell swoop.

(Click the first and shift click the last file to select everything in between.)

John wrote:

Thanks, when I loaded the software I used the default
settings for the directory structure. I couldn't find
a 'temp' directory. Any suggestions on where to look?

Thanks for your help. John

-----Original Message-----
John,

Clear out (delete) the files from your temp directory(s).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"john" wrote in message
...
It take forever to load a worksheet (3-4 minutes). I
have a new, powerful machine. If I load the file on
someone else's computer it takes one second to load.
I've turned off my virus protection software, disabled
macros, and I'm at a loss at to why it takes so long to
load. Any suggestions? Thanks, John



.


--

Dave Peterson


john

Thanks
 
Cleaning out the temp directory worked!!! Thank you.
John



-----Original Message-----
This is the windows temp folder--not exclusive to excel.

Windows Start button
Run
%temp%
(both percent signs are needed)
Hit ok.

(it's the quickest way I know to get there.)

Depending on what's running, you might get some "can't

delete" warnings. Just
select your files around those.

When I do it by hand, I show the list in detail view and

sort by date. Then I
can get rid of everything before today in one fell swoop.

(Click the first and shift click the last file to select

everything in between.)

John wrote:

Thanks, when I loaded the software I used the default
settings for the directory structure. I couldn't find
a 'temp' directory. Any suggestions on where to look?

Thanks for your help. John

-----Original Message-----
John,

Clear out (delete) the files from your temp directory

(s).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"john" wrote in message
...
It take forever to load a worksheet (3-4 minutes).

I
have a new, powerful machine. If I load the file on
someone else's computer it takes one second to load.
I've turned off my virus protection software,

disabled
macros, and I'm at a loss at to why it takes so

long to
load. Any suggestions? Thanks, John


.


--

Dave Peterson

.



All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com