1. 

   omontero
   

   Member
   Joined: Oct '09
   Posts: 3

   Is there a way to avoid using structured references when referencing a cell in a Excel 2007 table?

   I know you can write the cell coordinates and it would work but Ill prefer to disable this functionality so I can click on a cell in a table.

   I had the same problem with pivot tables where every time I selected a cell I got the Getpivotdata function but I found how to disable this functionality.

   Thanks for your help.

   P.D. I like that functionality but sometimes I just need to use the old-school method.

   Posted 3 years ago #
2. 

   Hui
   

   Excel Ninja
   Joined: Jul '09
   Posts: 5,027

   There is an option under
   Options, Formulas, Working with formulas
   called Use table names in formulas
   Unselect that and see if that helps

   Posted 3 years ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums