Opening larger Excel files takes forever. HELP!

  • Thread starter Thread starter Reggie
  • Start date Start date
R

Reggie

While expanding an Excel file with Macros and VBA codes,
it started to take 15 minutes to open the file. It never
did that before. I thought it was the computer, as I
worked with HP's support yesterday with nothing they
recommended worked. I scanned the disk for errors,
defragment the drive, restored to a previous time, tried
to run disk cleanup(but it wouldn't prgress after waiting
3 hours), and finally did a non-destructive recovery.
Opening the same files works great on my notebook with
simular Office products is the reason I thought it was
the computer. HP support advised me to check with
Microsoft support.

Does anybody know why adding to an Excel file with Macros
and VBA would make it so now I can't open even a file
half that size with out waiting 10 minutes for it to
open? Will the same thing eventually happen to my
notebook? Is it a software issue, and if so, what?
The CPU usage is running at 100% the whole time it's
trying to open the file and it shows two Excel files not
responding.

Appreciate any help or advise!

Reggie
 
A number of things could be impacting this operation:

1. VBA code could be added to the template so it runs
everytime excel is started, in the code, there maynot be
compatible code with that version of Excel - maybe

2. http://support.microsoft.com/default.aspx?scid=kb;en-
us;262530 - third-party software impacting operation.

3. http://support.microsoft.com/default.aspx?scid=kb;en-
us;299372 - maybe

If the above doesn't work, repost query but could you
include specs like OS, App version, if anything else
started happening at the same time.


Cheers,
Franksta.
 
Reggie:
Have had that problem. Outlook was my problem. Just
answered cedwards similarly. Often Outlook is culprit
even if you don't use it! Must clean out your Journal
entries in outlook & reset so it doesn't save entries for
more than a specified period of time. Also dump email
messages in Outlook & Express & restart computer. This
solved my slow-start & save problem in Excel. Had 7,000+
(?) entries in the Journal, which I never use.
 
Back
Top