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
Solved

Excel 2010/2013 compatibility

Posted on 2013-10-29
4
501 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
  • 2
4 Comments
 
LVL 20

Expert Comment

by:marsilies
ID: 39611200
0
 
LVL 70

Accepted Solution

by:
Merete earned 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
You may have a outside contractor who comes in once a week or seasonal to do some work in your office but you only want to give him access to the programs and files he needs and keep privet all other documents and programs, can you do this on a loca…
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…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

828 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