?
Solved

Excel 2010/2013 compatibility

Posted on 2013-10-29
4
Medium Priority
?
511 Views
Last Modified: 2013-11-11
I have an Excel 2010 macro enabled document that when opened with Excel 2013 gives me the error that the macros are unavailable when I try to use them. I tried saving the document in 2013 but the macros still do not work as they do in 2010. Any ideas on how to get around this? I need one format that works in both versions. All users on Win7.
0
Comment
Question by:Buckeroo_Banzai
[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
  • 2
4 Comments
 
LVL 20

Expert Comment

by:marsilies
ID: 39611200
0
 
LVL 70

Accepted Solution

by:
Merete earned 1500 total points
ID: 39612983
Hi, if the above doesn't help, I sourced this.
It's pointing slightly to look at a different avenue,
 First check that the macro doesn't point to a macro on a different system with the same file name located in a different folder
Secondly check if you have an ambiguous macro name.
This the  SOURCE of where I got my ideas from, he answered as a two fold problem with those references.
0
 

Author Comment

by:Buckeroo_Banzai
ID: 39624601
Hi masilles, yes we did check those settings. The marcos are enabled.

Merete - I will look into that possibility. Thanks to you both for the suggestions.
0
 
LVL 70

Expert Comment

by:Merete
ID: 39628557
Very good Buckeroo_Banzai,  it strikes me as a good area to look into.
Hope you find some answers. Please let us know so we can help you further.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
Suggested Courses

752 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