Excel Defined Name Manager Not Working to a Link Database

[legalhustler]

Good Afternoon.

I have Excel worksheet that is linked to a Access Table. I imported the Access Table to Excel (which creates a dynamic Excel table) I then simply added two extra columns (which uses a formula) at the end of the Excel table then created a defined named for the whole table with the additional columns as "LogTable". I then created defined names for the two individual columns as "Quarter" and "CycleTime".

I wanted to do some further analysis on the data and tried to use the formula nomenclatures, such as LogTable[Quarter] or LogTable[CycleTime], but the [Quarter] and [CycleTime] does not show as defined names, only the LogTable. Is it because it's not part of the import process? How can I get it to work?


TIA!

 

[legalhustler]

Ok, I was able to figure it. When I imported the database it defined the Table name already (Found out by highlighting the Quarter/CycleTime column after entering a formula). I had to use the original Table name that was given when I imported the Access Table. Now it picks up the Quarter and CycleTime defined names