Solved

Microsoft excel has stopped working - after updating a filed

Posted on 2013-12-19
11
330 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
11 Comments
 
LVL 95

Accepted Solution

by:
John Hurst earned 250 total points
ID: 39729183
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
ID: 39730862
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
ID: 39734381
i will try your suggestions and let you know...
thanks
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:sikadmin
ID: 39734567
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 95

Expert Comment

by:John Hurst
ID: 39734568
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
 

Author Comment

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

Expert Comment

by:John Hurst
ID: 39734575
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
ID: 39734583
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 95

Expert Comment

by:John Hurst
ID: 39734588
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
ID: 39734929
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 95

Expert Comment

by:John Hurst
ID: 39779834
@sikadmin - Thanks and I was happy to help.

.... Thinkpads_User
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

729 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