[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 520
  • 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

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.

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