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]
Ian Page commented
About time MS spent a few of its squillions of $$$ and actually enhanced Excel for Mac instead of knee-capping it.
Danilo Torres commented
Yes, please bring it back!
yes, yes, 100 x yes, bring it back. It was there before, likely this was just a oversight on MS's part.
Louis Kutcher, PhD commented
I am a fairly advanced Excel user and frequently automate what I do with macros. For complex macros, this isn't much of an issue since I will likely play around with the code anyway. However, for a simple macro (like insert a row, copy some data, and change the formatting) I'd like to be able to just record the macro then run it on any row I need in a given spreadsheet.
When is Relative Reference Macro returning to the Mac? I purchased 2016, it wiped out my 2011, and this is a feature I need every day.
Dominic Liang commented
Hi, I have been working with excel on Windows and just moved to a Mac. Its been difficult to do the basic functions and when I am learning advanced excel, its difficult to follow the instructions as so many of the functionalities in windows are not present in Mac. One of them is the 'Use relative reference' feature and I hope the team works around to do something about this.
Hi all, I'm just getting started learning about VBA and have read a number of forums indicating that recording using relative refs isn't available in Excel 2016 for Mac. Is this still the case? I've seen posts and requests since 2015 to have this upgraded, and will be surprised if MS hasn't done it yet.
Please bring back the Relative References in Macro recording, its very difficult to run Macro's without it!
Please bring back the Use Relative Reference button on the Developer ribbon!!!!!!!!
I agree with the previous statements - please bring back the Use Relative Reference button on the Developer ribbon!
Scott Thompson commented
This isn't about "code that used to work that is no longer working". This is about the inability to record a macro using relative references - the default is to record cell references using absolute references, and there appears to be no way to change that setting.
This is a screencast of recording two macros in Excel 2011- one recorded with Relative References, and one recorded without. The difference should be pretty clear.
And the spreadsheet file itself;
To reiterate - this code will RUN in Excel 2016. The issue is that you can't RECORD code like this in Excel 2016.
(If you need an explanation of why relative references themselves are useful then please let me know. I would hope that for anyone spending any time with VBA would find it self-evident.)
Ron Lunneman commented
Why would you create an updated version of something that is inferior to the 'outdated' version? This is gross
I have a long list in one column I have to sort and to spread in 4 columns. It's not possible with a macro and not have relative references. I have a monthly subscription for MS Office so I cannot use older versions. Please make this active otherwise my subscription is not adding value...
This is a CRITICAL function that is missing from Mac/2016. Why force me to use the Windows version?
Seriously, this has completely tanked my ability to create macros, hoping i have not upgraded my mac at home so i can complete this macro... ADD BACK relative reference toggle, please!!
Mann Shoffner commented
A Relative Reference button has been a function in Excel since the 1990's! Why is Microsoft deciding to remove it?!
Touched bases with Philiip and got a link to the answers post where this is discussed: http://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/record-macros-with-relative-references-in-office/8098f458-66b3-4546-a4f2-9b9bb8492c6b?auth=1
I've also added a screenshot to this request to show the difference between Mac Excel 2011 and 2016.
Phillip Jones commented
As a CM at answers forum I read all the questions and there is a Long thread about this subject. Some of the people are Business people. All the people are using in their work. So it's vitally needed.
Can you please give an example of the code that used to work, but is no longer working?