I am trying to access a SQL database (MS CRM 4.0) using the Connections feature in Excel 2007. I am able to connect to various tables and views, however, some key columns of data do not appear. I am wondering if they are hidden or I have a security issue. If I try to access the data using SQL Server BI 2005, all data is available. However using Excel 2007, the columns I need to connect the data to other tables is missing. Any thoughts?
