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]
I think we ALL know this thread is being ignored. It isn’t ever coming back to the Mac version.
Weichen Zhang commented
It's Nov 2018 now and the problem is still there.
How can Mac Excel remove this vital feature and how long will we wait for an update?
This is a much needed item which I used regularly
Lee Aronson commented
Absolutely, bring it back!
I'm getting my MBA online and taking an advanced Excel class. I CAN'T DO MY ASSIGNMENT BECAUSE I DON'T HAVE THIS STUPID BUTTON. What happened? It was right there, next to the record button in the last version of excel for Mac? It seems like this would be a pretty critical function for ANYONE who uses macros. One button. Seriously.
YES!! Bring it back.
Bring it back!
Phillip Jones commented
It is absolutely a Bad idea to remove the ability to use "relative reference" Absolute reference, breaks with the least effort. Even the making of websites. it frowned upon to use absolute Reference.
Sten Smed commented
I bought Microsoft Office 365 to get access to Excel with the macro function and the Relative References as one of the most important features. It was for me so clear that this function existed, so I didn't even tested for one free month.
Now I will try to get my money back, and definitely stop any more payment in the future.
I didn't get to sleep until four a clock this morning, trying to find out where the function was hiding.
Time to look for a competitor product to Microsoft Exl on MAc
I need a selection arrow in excel urgently.. I asked different friends and they have the same issue. T
what a 'great' way to cripple a program... I can't even 'use' EXcel anymore... it is now useless.... "you're 'dead' to me!!!"...
Might this be time for a class-action lawsuit for M$'s intentionally crippling a product so that it can't run on a previously supported competitor's platform? That strikes me as restraint of trade. This kind of malfeasance has been going on ever since Excel 2011 -- the last functional version for the Mac.
It's unbelievable that I needed to do this... but I copied my spreadsheet into a Google Sheet (which allows you to create macros with relative references) so I could use that basic functionality.
Yes, free Google Sheets has this feature that Excel Mac 2016 doesn't have.
Luis Macias commented
Please bring back Relative References in Macro Recording
[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