DixiePiper
New Member
- Joined
- Oct 19, 2015
- Messages
- 41
- Office Version
- 365
- Platform
- Windows
I've searched every way I can think to phrase this question and I cannot come up with a solution. I have a large macro-enabled template that uses a lot of tables for data lookup. I'm used to writing my formulas using the table names and column headers to avoid having to switch back and forth between tabs. For some reason, in this workbook, when I type out the formula, it will pull the table name but it doesn't give the drop down of column headers. I've verified that "use table names in formulas" has been checked. I started to rebuild the workbook but only a handful of tabs in and I was running in to the same issue. I created a simple test workbook and everything works just fine. Any idea what might be going on and how to fix it?
I'm running Excel 365 in a Windows environment.
Thanks in advance for any help.
I'm running Excel 365 in a Windows environment.
Thanks in advance for any help.