Solved

Microsoft excel has stopped working - after updating a filed

Posted on 2013-12-19
11
320 Views
Last Modified: 2014-01-14
Hello,
one of my users has created an excel file (with excel 2010) he put there a filed that can be chnaged and than many calculation in the excel sheet will be update accordingly (e.g.: discount price, each time some one changes this field many other fields are being updated)

another user (which has excel 2013) open this file and when he changes this filed , the excel is getting stuck, i get an error message: excel stopped working, and the file crashes.

the original user who created the file and has excel 2010 is doing the same operation and it works fine,

the file is located on our shared storage file system
0
Comment
Question by:sikadmin
  • 5
  • 4
  • 2
11 Comments
 
LVL 90

Accepted Solution

by:
John Hurst earned 250 total points
Comment Utility
On the problem machine with Excel 2013, try loading it without add-ins, or disable add-ins and try opening the file again. Since the file works in Excel 2010, it could be an add-in in Excel 2013 causing the problem.

You can also go to Control Panel on the problem computer, Programs and Features, click on Office and do a full repair.

... Thinkpads_User
0
 
LVL 14

Expert Comment

by:Zack Barresse
Comment Utility
Is this 32-bit Excel? Try disabling hardware graphics acceleration. Click FILE, Options, Advanced, look under the Display options, check the box. I'd certainly try the other suggested things too.

What hardware differences are there?

Zack Barresse
0
 

Author Comment

by:sikadmin
Comment Utility
i will try your suggestions and let you know...
thanks
0
 

Author Comment

by:sikadmin
Comment Utility
tried them all. nothing helped.
i think it may be a bug in office 2013
it happens to all users who has office 2013, but for users with office 2010 it works fine.
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
it happens to all users who has office 2013

Try making a new worksheet on an Office 2010 machine and then copy the data and formulas from the problem worksheet. Test and save the new worksheet with a new name.

Now try the new worksheet on the Office 2013 machine.

... Thinkpads_User
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:sikadmin
Comment Utility
do you know if i have office 2013 on my laptop, can i install also office 2010 in parallel ?
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
I don't normally do this. It works for some and not for others. Since you have Windows 7 (and presumably Windows 7 Pro) you can download XP Mode for free from Microsoft and install Office 2010 in XP mode.

I handle different versions of Office by using Virtual Machines. XP Mode will do that for you.


... Thinkpads_User
0
 

Author Comment

by:sikadmin
Comment Utility
so you mean:
i have office 2013 on my computer as my main office
and than i also have office 2010 in XP mode that acts as office 2010 installed on XP machine..
correct ?
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
Yes, that is what I mean. Office 2010 (in XP mode) will be independent of Office 2013. It is like using a different machine.

You could use a different machine to start the testing.

... Thinkpads_User
0
 
LVL 14

Assisted Solution

by:Zack Barresse
Zack Barresse earned 250 total points
Comment Utility
While it's not supported, you can install Office versions side-by-side. The only exception is Outlook, where you can only have one. The key is to install them from the lowest version first, then progress through all versions desired. I have Office 2003-2013 installed on my machine. A VM is another good idea because of true segregation/environment. It's not needed though.

For Excel it works pretty good, but for the other apps, generally it will do a small registry write/check when opening, and if it's not the latest version you'll see the 'Updating Office' dialog box/progress bar when switching between versions. If you *just* install Excel with multiple versions you won't see this problem.

And I wouldn't run ANY Office version in XP mode, but recommend to keep them in the same flavor of Windows you're running. If you need to change the OS, definitely use a VM. Anything else is either a bad idea or a complete waste of time.

Zack
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
@sikadmin - Thanks and I was happy to help.

.... Thinkpads_User
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now