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]
Found an alternative to Microsoft - OpenOffice.com does macros but haven't tried them yet...
This may be deleted rather quickly!
I agree with Jack - time to find another piece of software that does this properly. Microsoft have lost the plot - and their loyal followers.
Anyone know of an alternative? Does Libre Office have macro capability? It has the advantage of running properly on Linux and Mac.
Can we expect that the "this Fall" issue of VBA for Mac Excel will include Relative References?
I've used that option (readily available in the Windows world :-( for virtually all of the macro recording I've used to develop highly complex, user-interactive data preparation workbooks for one of the largest construction companies in the world. Without that ability, Office 365 is useless for me, and I will lean towards anything I can find that replaces it.
... and it's not just the relative button that's missing...
Theres NO WAY of designing input forms because the VBA editor no longer supports them.
Microsoft has basically deleted macro and VBA capability on Excel for Mac 2016. I want my money back - now!
This hasn't been fixed yet for Office365 users. Microsoft, please restore this function. I've just wasted hours trying to figure out how to do it by hand, and I'm no VBA user... Seems like there's no point in continuing to give you my money.
Gerald Small commented
Need this option restored in Excel 2016 for Mac. Complete nonsense to remove this feature!
Is this the best way to get people to leave their Macs for a Windows machine? Exactly why I've left windows.
I would add a million votes to this if I could. Really, this is just a joke that it isn't included. It is in the 2011 version, so the code is there.
bring this button back!
This isn't the only thing that has disappeared in Office 2016. Word has lost its "Publisher Layout" making it impossible to edit old documents created on 2011. No reason given - Microsoft just does it!
Is there a forum for Word like this one?
2017 June 5 --- It is unbelievable that Microsoft has not restored the functionality of Relative References in Macro Recording in the current version of Excel Mac 2016. Microsoft, please get off your dead *** and do your job!
one two three commented
James Goodwin commented
Any danger Microsoft
I shall say this again. Microsoft should give all registered users a "downgrade" to 2011 immediately. This release is bordering on a scam. We expect "upgrades" to better than the previous version, not worse.
We have all paid about £75 for a useless piece of software.
Susan Jimenez commented
Must add Relative Reference back to the Developer. Macros are worthless without it.
People have been complaining about this since Oct 22, 2015, 18 months ago. Microsoft has had 18 months and not resolved this. I must conclude that they don't care that they have removed such an essential feature (relative addressing in macros).
This situation is unbelievable. When a software provider updates its software you normally expect it to be better than the previous version, or at least as good as (with some extra bells and whistles that no one wants). But this is something else.
"Hey chaps we've brought out a new version - a major upgrade so it's called 2016 instead of 2011!!!!" What arrant rubbish - Microsoft should be ashamed of this and give us all a free downgrade to the better, older version. We have all registered our software so it should be child's play to send us the down/up grade.
What about it Microsoft? Do the decent thing and admit you have messed up!
For me the absence of relative references makes macros useless: I am now going to have to perform the same set of operations 180 times by hand
Please reinstate the relative / absolute button, Im astounded that Microsoft would choose to shoot themselves in the foot by deleting so many features in the 2006 "upgrade" :(
I believe the number of cases is extremely limited where the default behavior (absolute references) is appropriate. Elimination of Relative References basically makes the Macro Recorder useless.