• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 522
  • Last Modified:

Excel 2010/2013 compatibility

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
Buckeroo_Banzai
Asked:
Buckeroo_Banzai
  • 2
1 Solution
 
marsiliesCommented:
0
 
MereteCommented:
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
 
Buckeroo_BanzaiAuthor Commented:
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
 
MereteCommented:
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

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now