Solved

Excel 2010/2013 compatibility

Posted on 2013-10-29
4
491 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 19

Expert Comment

by:marsilies
Comment Utility
0
 
LVL 69

Accepted Solution

by:
Merete earned 500 total points
Comment Utility
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
Comment Utility
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 69

Expert Comment

by:Merete
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now