Bring back Relative References in Macro Recording
In Mac XL 2011 You had ability to create Macros that made use of Relative References in a addition to absolute references. In the Excel Mac 2016 Answers forum this is vitally important.
Any possibility of returning this to Excel Mac 2016
[10/22/2015 - Dan [MS]: Added image to show where this feature used to exist in older versions of Mac XL]
If you have version 16.24 or greater, you can now record macros using relative references.
Thanks for all your support for this feature.
Steve [MS Excel]
[Deleted User] commented
************************. I'm hoping this is the thread. If you look at the attached image from ************************* you will see relative references there (in the MAC XL 2011 version). It is no longer there in the MAC Excel 2016 version. These other threads indicate it too. It causes headaches as I try to teach goodness you can do in Excel but only if you have Windows but not MAC. Contact me directly with questions, lets speed up this feedback and getting it resolved. If Excel Online had the feature at least I could direct them there.
carverj at byui.edu
Elena Escobar commented
Please bring back Relative References in Macro Recording.
Having the button to change Absolute/Relative references for recording macros would greatly assist non VBA coders. Please add it to the Mac version of Excel
sachin handibag commented
bring it back buddy....why you remove this...you have to add on features not remove
Mike Ratcliffe commented
Crazy this feature is no longer available. BRING IT BACK!
David James commented
In response to Brian Edwards, surely you can simply select the 570 rows (one column wide), copy them and then paste to the next column. Or have I missed something?
Brian Edwards commented
I have a single column of 570 rows long. I need to put the data into 3 columns and doing it by hand will take hours. This used to be easy in older versions of Excel. Please restore this functionality.
This thread started in 2015 and now it's 2018. Please bring this feature back.
P Sach commented
Ridiculous that this feature is missing on Excel for Mac. Hope they will include it soon!
Please ! 🙏🏼
This is beyond ridiculous! It's not like MS would be losing a whole lot from including us Mac people and giving us the same program! Begs the question, what else have they left out of the Mac versions??
David James commented
It’s not just a single omission (relative setting when recording macros). When you use the recording facility the code created is very different when using absolute to that using relative. So it is not a simple editing job to turn recorded code from one to the other. One of the other things that is missing is the ability to create user forms. It is completely missing in the 2016 version making the macro capability pretty useless for anything serious.
It is obvious why this was done by Microsoft - it saves money on a feature which is little used outside of research, specialist and hobby use. The vast majority of Excel users prefer emojis to macros. Sorry - it is true.
There is a bit of confusion in some of the responses. You can USE relative references in macros, either by hand-editing the references, or by using macros recorded on a PC. You just can't RECORD macros using relative references. Which is a very odd omission, given that it was there before, and surely must be a common use-case. Pretty much all of my macros use relative references to iterate over a table and perform actions depending on the contents of the cells.
Marco Lazatin commented
I just found out that macros done in the windows version and then used on the excel for Mac has this capability. In other words the capability is there, they just took out the buttons to activate it in excel 2016. Microsoft's way of telling us "Please come back home to Windows".
This makes my works as a student/intern much more difficult. Would love this to be added back. I have no formal experience with VBA, just some self-taught things, so this feature is one of the only ways I can code (somewhat) effective macros that save me time.
This thread started in October 2015.
Microsoft hasn't addressed the issue.
Conclusion: Microsoft doesn't care.
Please do this!!!
It's a good thing I still have Excel 2011 hanging out on my computer - it actually allows me to do this. To complete my work, I have to have 2016 and 2011 versions open, bouncing back and forth between them so I can record Macros with relative references - which is insane. Why the heck would 2016 get rid of such a useful and necessary feature? Bring it back!
I find this situation unbelievable. I didn't expect to lose functionality by upgrading and paying Microsoft more money. Please sort this out as soon as possible.
And just in case you missed the post from Feb 7, 18:
I am convinced that MS has intentionally "shorted" their Mac customers on this feature. Macros are nearly useless with a relative reference capability. Unless MS's attitude towards the people who pay their salaries changes, they will die out just like Lotus 123, Novell, Wang, MultiMate, dBASE, and a host of other firms who could not bring themselves to understand what their customers' needs were. MS has been ruining their user interface for years. They claim to have usability labs, and then they "disorganize" their menus. The old saying" Designed BY programmers FOR programmers" continues to be proven true by MS. I don't even know why I am bothering to write this, except for the cathartic value. MS is ignoring all of us and our comments. They are being petulant in their feuding with Apple, and we bear the brunt of the pain as a consequence. MS is basically a non-creative bureaucracy now. Apple products, while not perfect, are much more usable. Apple has its share of smarminess (people whose job title is "genius" is really stupid, like the stupid car called "Smartcar"). The eye rolling caused by such "tin ears" is legendary. Computers are high speed idiots, but compared to MS, at least they are high-speed. I don't love either product. I am more satisfied by and large with Apple. But there is plenty to dislike about both.
Back to the topic at hand: c'mon MS, do you want us to beg you to help us? Fix the **** thing already!
Please explain how macros are useful with only absolute references. Please give me (and everyone else) a link to an explanation or tutorial on how to make useful macros with only absolute references.
PLEASE bring back relative references in macro recording. I need it for my study of VBA programming.