sikadmin
asked on
Microsoft excel has stopped working - after updating a filed
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i will try your suggestions and let you know...
thanks
thanks
ASKER
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.
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.
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
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
ASKER
do you know if i have office 2013 on my laptop, can i install also office 2010 in parallel ?
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
I handle different versions of Office by using Virtual Machines. XP Mode will do that for you.
... Thinkpads_User
ASKER
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 ?
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 ?
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
You could use a different machine to start the testing.
... Thinkpads_User
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@sikadmin - Thanks and I was happy to help.
.... Thinkpads_User
.... Thinkpads_User
What hardware differences are there?
Zack Barresse