Open a 4mb excel file hangs my excel

When i open my excel file in excel 2007 or 2010 in different computer, it will hang the excel program, other excel files are okay.

What should I do?
sharepoint2013Asked:
Who is Participating?
 
aikimarkConnect With a Mentor Commented:
copy the .xla file to a file server, available to everyone, and have the users add it to their environment.
0
 
stlhostCommented:
Look for MS updates related to Excel in the past month or two specifically KB973475 and uninstall them.
0
 
sharepoint2013Author Commented:
did a search for KB973475 and no match found
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
gowflowCommented:
It seems you hv an instruction in the macro that 2007 or 2010 doesn't like. try opening the file with macros de-activated
first open blank excel goto office button on top left corner click on Excel Options then Trust Center on the left pane then Trust Center Settings on the right then Macro Settings and make sure the third option is clicked which is
Disable All Macroes With Notification

close Excel
Start your workbook
check if it hangs (it should not) and you will get a button close to the address bar that says options

At this stage If it did not hang this means it is a macro related instruction

I suggest here you put in the workbook open event this instruction
msgbox("X")
then save the workbook close it and then run it again and activate macros once it give you a popup with X just press break mode and then f8 for each instruction to see where it is freezing

gowflow
0
 
sharepoint2013Author Commented:
it still hangs.
0
 
gowflowCommented:
where when you open it and deactivate macro ? do u hv macro in that file ?
gowflow
0
 
gowflowCommented:
Could you post the file ?
gowflow
0
 
sharepoint2013Author Commented:
0
 
sharepoint2013Author Commented:
can help?
0
 
Jackie ManCommented:
Is the excel file stored in local drive or a network drive or a USB drive?
0
 
aikimarkCommented:
it is trying to reference an add-in that doesn't exist on the problematic systems.
0
 
sharepoint2013Author Commented:
local drive.

@aikimark how do i solve this?
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.

All Courses

From novice to tech pro — start learning today.