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

this Excel file takes forever to load.... why?

The opening of the attached file takes forever on my Excel 2007 and Excel 2010. I killed Excel after 45 minutes waiting!
Can you understand what's the problem in it?
Segreteria.xlsm
0
lucavilla
Asked:
lucavilla
  • 3
1 Solution
 
Martin LissOlder than dirtCommented:
I run Excel in XP in a virtual window on my MAC and like you when I first tried to open your wb it started to take a long time so I used Apple's Force Quit to end Excel. When I reopened Excel it showed me the temp file it had saved. Clicking on 'Repair' for your WB opened the workbook instantly with a "no repairs needed" message. Here's the resulting file that opens normally.
Segreteria.xlsm
0
 
lucavillaAuthor Commented:
Thanks!  However it appears corrupted in all the sheets...
Can you try to delete the sheet 12 from the original file? the problematic sheet seems that...
0
 
lucavillaAuthor Commented:
Solution:

1, Create copy of the file
2, Rename the original file to e.g. MyFile.ZIP
3, then open the ZIP file and find folder 'xl'
4, under the folder 'xl' find a folder called 'worksheets'
5, you can see that the 'Sheet12.xml' has 52 MB !!! This is the problem
6, just delete the Sheet12.xml file
7, copy e.g. Sheet1.xml at the same folder and rename it to 'Sheet12.xml'
8, close the ZIP file and save changes
9, rename the file back to whatever it was before including the extension like Mybook.xlsm
10, open it

Of course you will lose the sheet 12 which contains too much data and formulas but at least you can get the rest.
0
 
lucavillaAuthor Commented:
got from other source
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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