I was working on an spreadsheet at work with an Excel table and I set up some SUMIFS formulas using structured references. I took the spreadsheet home with me and opened up the spreadsheet at home and all of the structured references had changed to A1 style references.
If I create a new SUMIFS formula at home Excel turns it into a structured reference, but the original ones (the ones I did at work) stayed in A1 style.
Upon getting back to work the next day, the formulas I did at work revert to structured references but the ones I did at home (which were structured references at home) change to A1 style.
Does anyone have any idea what's going on with this?
Both at home and at work I'm using exactly the same version of Excel (2011 for Mac).
Thanks to anyone who might help.
If I create a new SUMIFS formula at home Excel turns it into a structured reference, but the original ones (the ones I did at work) stayed in A1 style.
Upon getting back to work the next day, the formulas I did at work revert to structured references but the ones I did at home (which were structured references at home) change to A1 style.
Does anyone have any idea what's going on with this?
Both at home and at work I'm using exactly the same version of Excel (2011 for Mac).
Thanks to anyone who might help.