• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 404
  • Last Modified:

1 excel file takes about 5 minutes to load

Hello Experts,

I have a user who uses an particular excel file everyday. It resides on our DC, and if you open the file office will launch look like its loading the file, crash, then start loading it again and the second time the file will open. In total it takes about 5 minutes to launch the file.

I have had the user copy the file to the desktop and launch it from there but it does the same thing. I have even tried using a completely different computer but the file take 5minutes to load.

I'm going to format the users computer to fix some of the problems occurring there but I cannot for the life of my figure out what is up with the excel file.
0
nicolausj
Asked:
nicolausj
  • 10
  • 7
  • 3
  • +1
2 Solutions
 
redmondbCommented:
Hi, nicolausj.

A few questions, please...
(1) What version of Excel?
(2) What's the extension type of the file (.xls, .xlsx etc.).
(3) Can you give any details about the crash, e.g. error code, description?
(4) Can you give us some details about the file - size, links to other files, formulas, macros?

Thanks,
Brian.

0
 
viralypatelCommented:

One of these will solve the issue:

------------
clean the temp folder and try opening it ... should make a difference.

Start-> Run
Type %temp%
delete all files in the folder
open the excel file again

----------------
It could also be taking a long time to open if the data in there is huge and is used in too many pivots. Remove unwanted pivot tables and hidden spread sheets that you may not be using any more. This too will help improving the speed.

-------------------
Finally, if it is just static data, copy it to a fresh spread sheet and save it again.
0
 
nicolausjAuthor Commented:
Hi Redmondb,

It was created a few years back using office 2003 as a .xls. At the beginning of this year we installed Office 2007, at which point the user converted most her .xls files to .xlsx files.

To be honest there really aren't any crash errors, I have looked at both the pc and server for any errors, the server has no errors, but the computer has the following error at the time of the crash.

"Hanging application explorer.exe, version 6.0.2900.5512, hang module hungapp, version 0.0.0.0, hang address 0x00000000."

I'm not really an excel user, but I think there are sheets the point to other sheets in the document, and basic formulas. The file is 10MB in size.


0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
redmondbCommented:
nicolausj,

Thanks. This sounds like a more fundamental problem...
 - I've seen corrupt files take down Excel, but not Explorer.
 - You mention formatting the user's PC "to fix some of the problems occurring there".

Assuming there's no confidential information in the file, could you post it here please? If that's not possible, viralypatel's suggestion about rebuilding the file is a good one.

BTW, what are the other problems on the PC?

Thanks,
Brian.
0
 
nicolausjAuthor Commented:
Sorry, but unfortunately there are confidentiality reasons I cannot post the file.

Mostly the computer has been acting a bit sluggish lately, slow to open almost everything. I have been trying to determine if the problems were Profile based, hardware issues, or software.

We recently updated our AV to Symantec 12.1 and a lot pointed to the update, after uninstalling the AV the computer gained a bit of speed, but not enough for the user to notice. I re-installed Symantec but the the antivirus module, skipping all the other stuff included.

I have updated the bios, and network drivers, double checked all windows updates have been applied.

I also have run mbam in safe mode to make sure there is no spyware, and there is non
0
 
nicolausjAuthor Commented:
I was thinking of saving the file as a comma delimited file, then opening a new workbook and loading the data.... but there doesn't seem to be that option in excel 2007
0
 
redmondbCommented:
Thanks, nicolausj.

Please try viralypatel's rebuild suggestion. If that doesn't work, use the same process to strip out the confidential information and post that version - assuming it's still misbehaving. (If it isn't misbehaving, then put back bits until it does.)

(I'm very reluctant to go down the virus route, but the best s/w running under an operating system will often miss a root-kit. It may be worth downloading a good stand-alone anti-virus and burning it to CD on another PC.  Then use the "bad" PC's anti-virus to scan the CD. Finally, boot the "bad" PC from the CD and run a scan.)

Regards,
Brian.
0
 
redmondbCommented:
nicolausj,

Apologies, crossing post. Yes, 2007 will save as CSV. The attached is 2010, but it will be similar to 2007.

Regards,
Brian. Save As CSV
0
 
andrewssd3Commented:
If you still have 2003, does it still open on that?  Excel 2007 introduced some horrendous problems with charts - if it contains charts that is a likely cause of the problem.  The worst issues are with x-y scatter plots with large data ranges, and other chart types where the ranges are large say 10-15,000 rows. The other thing I have seen causing this sort of problem is when large numbers of drawing objects get created on a sheet - say by a repeated macro copy process.  Thousands of objects can build up.  When you do get it open with Excel 2007, check each sheet using the Selection Pane which is accessible from the Home tab.
0
 
nicolausjAuthor Commented:
I will try all these suggestions tomorrow... the user is currently in the file.

Thanks,
0
 
nicolausjAuthor Commented:
Still haven't had a chance to try any of your tips. I hope to get to it this afternoon or first thing tomorrow.

Thanks
0
 
nicolausjAuthor Commented:
Still not sure what is causing the problem with the excel file.
0
 
redmondbCommented:
nicolausj,

Given that you're having general problems on the PC, the Excel file is unlikely to be the source. I'd suggest closing this question (allocate the points to viralypatel) and open a new one in the appropriate Windows zone (plus anti-virus).

Regards,
Brian.

0
 
nicolausjAuthor Commented:
The pc has been replaced with a newly formatted pc. It has something to do with the excel file.

I have eliminated the computer and Anti-virus.
0
 
andrewssd3Commented:
Have you tried my suggestion? Open it up and take a good look at the contents.  I bet you'll find either charts, drawing objects, or something else unusual - maybe lots of worksheets, etc.
0
 
redmondbCommented:
nicolausj,

Did you try viralypatel's suggestion? andrewssd3's suggestion is a good one too (apologies, andrewssd3, I hadn't noticed your earlier post).

 If neither one help, please strip out the confidential information and post that - assuming it's still misbehaving. (If it isn't misbehaving, then put back bits until it does.)

Regards,
Brian.
0
 
andrewssd3Commented:
I agree with redmondb - what we really need here is a sample file. Could you dummy out names or randomise some figures so it doesn't mean anything and post the file?
0
 
nicolausjAuthor Commented:
I wish I could upload the file... I might just have to call it, and tell the user to recreate the file.
This Friday the user isn't in and I will have the whole day to look at the file.

Thanks for all your help, I will post back any new information on Friday.

0
 
nicolausjAuthor Commented:
I'm going to split the points between redmondb and andrewssd3. The issue has not been solved but I'm not really sure what I can do when I cannot post the file.

0
 
nicolausjAuthor Commented:
I have no idea what is going on with this excel file. I do know its the file that's the problem because we have accessed it from multiple computers and run into the same issues.

Thanks for your input and giving me some things to test.
0
 
redmondbCommented:
Thanks, nicolausj. FWIW, I would have preferred you to leave this open while you tested the "some things" or to have requested that the question be deleted - Grade C is a comment on the support provided by us.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 10
  • 7
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now