?
Solved

Microsoft excel has stopped working - after updating a filed

Posted on 2013-12-19
11
Medium Priority
?
333 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 97

Accepted Solution

by:
Experienced Member earned 750 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 97

Expert Comment

by:Experienced Member
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 97

Expert Comment

by:Experienced Member
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 97

Expert Comment

by:Experienced Member
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 750 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 97

Expert Comment

by:Experienced Member
ID: 39779834
@sikadmin - Thanks and I was happy to help.

.... Thinkpads_User
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

765 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