Excel Defined Name Manager Not Working to a Link Database

legalhustler

Well-known Member
Joined
Jun 5, 2014
Messages
1,091
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!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

legalhustler

Well-known Member
Joined
Jun 5, 2014
Messages
1,091
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,293
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top