I am a long time PC user in Excel but now using a Mac at work. Generally the transition has been relatively seamless except for one area: Tables.
Whenever I try renaming a table in Excel for Mac, the new name appears in the Name Manager along with the old default name and it looks like the newly named table is just referencing the old table. When I write formulas to reference column names, those references only work with the old default table name instead of the new table name. Is this a known glitch? It is driving me crazy and I use tables often enough that I can't continue calling them Table1, Table2, Table3 etc.
Just as a visual it looks something like this:
=sum(Table1[Amount]) a very standard formula when I rename tbl_data, there is not option for [Amount] to appear. Hopefully this is an easy fix and I am missing a step because this could mean I will need to demand some kind of PC fix whether using Parallels or VMWare Fusion...would rather not but I may have to.
Whenever I try renaming a table in Excel for Mac, the new name appears in the Name Manager along with the old default name and it looks like the newly named table is just referencing the old table. When I write formulas to reference column names, those references only work with the old default table name instead of the new table name. Is this a known glitch? It is driving me crazy and I use tables often enough that I can't continue calling them Table1, Table2, Table3 etc.
Just as a visual it looks something like this:
=sum(Table1[Amount]) a very standard formula when I rename tbl_data, there is not option for [Amount] to appear. Hopefully this is an easy fix and I am missing a step because this could mean I will need to demand some kind of PC fix whether using Parallels or VMWare Fusion...would rather not but I may have to.
