Excel Connection Properties Greyed Out



In the Password to modify box, enter a password and click OK. For example I have a list of dates in Column A and I want to run the query for each dates shown in column B, so the paramter for B1 is A1, B2 is A2 etc. When I go back in, the password is gone. Document properties are grayed out All of a sudden the document properties in my doc are now all grayed out. This page will show you how to convert Excel data into a table. I would like it to refresh every 60 minutes. Issue: When users will try to export e. Excel Import. Configuring the Import Environment You can use the Import Wizard to customize your preferences for the import environment and import data using the different methods like Insert, Insert Script, External Table, Staging External Table and SQL*Loader. On the Select Data Source window click on the “hidden or empty cells” button located on the bottom left of the window. Excel immediately triggers a refresh of your external connection, bringing in your new data. Connection information and queries will be available after upgrading to a new version of Excel. NET page? how to maintain connection with excel while data change is rapidly. Feel free to add your own tips and tricks using the 'add comment' link. For large data sources use ByD OData parameter to select and filter ByD data. and there I saw option 'Refresh every x minutes` grayed out. The connection passes an SQL Select statement to a MS SQL Server via OLE DB. Guest Post by Ted Eichinger Note, this fix to re-establish a broken connection is performed using Excel 2010 It's the same old story, I mashed and twisted some data through Power Query, pulled it through Power Pivot, spent hours creating calculated columns and measures, made a really nice Pivot Table with conditional. It's easy to tell that the InfoPath form controls have properties, have settings. More precisely, you can only read the Value and Formula properties for a single-cell objects. Excel Powerpivot Table Properties Greyed Out. 2 Small Macro problems. Unless you’re using some of the more advanced features you might be able to get away w/o the 2010 features so that your colleagues can collaborate with you using their versions of Excel. To rename an Excel table, first ensure that the Design contextual tab is active, and then, in the Properties group, edit the value in the Table Name field. On the Format Slicer pane, under Properties, select the Don't move or size with cells box. How do I have the Get External Data to be available?. See how to enable the Encrypt contents to secure data checkbox. com Visio Shape. Excel Formulas are much easier to read and write when working in tables. It started a couple of months ago, but has become quite aggressive lately. This article will help users to embed SQL Query in Excel 2010 and create a dynamic connection in Excel. So I can't make parameter query. You can define how to draw the layer, which data source the layer is based on, whether to label the layer, whether to specify scale-dependent display for the layer, and so on. Connection information and queries will be available after upgrading to a new version of Excel. Excel Import. The query name is also how the M code will reference this query if we need to query it in another query. The instructions in the workbook said: Open the “Data” ribbon. If you want to collapse the ribbon so that none of the buttons are displayed, double-click the name of the tab. Do one of the following: Create a new connection to the data source. To rename an Excel table, first ensure that the Design contextual tab is active, and then, in the Properties group, edit the value in the Table Name field. a Contacts list) does work!. odc file and VBA scripts are still possible, in Excel 2019 it seems that it is no longer possible to adapt the data model connection directly. Now that you know some basics of how tracking works in Excel, let’s talk about how to enable it, change settings and keep track of changes! Enabling Tracking. 1 (I think). Excel 2007 data query parameter issue button in the "Connection Properties"->"Definition" but the Edit Button is greyed out. Power Pivot Change Edit Connection Greyed Out Stack Overflow. In the example below, a web query is added to a worksheet. When I want to add a driver in the ODBC Data Source Administrator, the response is: "To install new drivers use the driver's setup program!". I have Excel 2007, and the workbook/worksheet is not protected. Document properties are grayed out All of a sudden the document properties in my doc are now all grayed out. Excel offers many different ways to paste information that you have copied. png I need to manually open the. On the Definitions tab of the Properties window, look at the connection string. Accessing it from my machine worked fine. There appears to be a setting for that in the properties of the connection, but they are all grayed out. Good Morning, I have been working with Spotfire for about a year now and this is the third time that this has happened. Step 3 − Click on the PivotTable button. For connections that are shared in the library, use the Manage Data Connections tool instead. Microsoft Data Connection Wizard Best Cell Phone Plans Compared Connection Properties Greyed Out Enable Background Refresh Excel Table External Data, list of verizon wireless certified devices, XML Format: Create PST in Outlook 365 Connection Properties Greyed Out iphone 3gs no data connection straight talk, MDAC 2. Excel grays out menu commands for unavailable features or functions. You need to talk to whoever is managing the overall network to address your question properly. How to Edit Data Connection Properties Note: Only data connections and connection data sources that are embedded can be edited within the context of the analysis. The normal way of formatting cells in Excel (highlight the area, then Format - Cells at the top of the screen) doesn't work for pivot tables. It's easy to tell that the InfoPath form controls have properties, have settings. I am unable to Edit Excel in Box anymore. Tag: Management Studio - Index properties grayed out 3 SQL Server 2000 job permissions All you need is in the thread below the Package owner and the proxy must be Admin leve permission because Access is not SQL Server. No ODBC Drivers available for Excel or Access. Q: How can I change connection information (server name, DB name, etc) for existing PowerPivot table? Note: These instructions will work just with the latest build of PowerPivot (not available to public). I’ve come across examples where Outlook is installed, but no email account has been enabled in Outlook – if that’s the case this button will be greyed out. In this tip we will learn about. Excel file connection How to upload xlsx 2016 into MSSQL 2017 using stored procedure in ASP. • Changed many properties from Integer to Single to better support vector graphics. Go to Data tab and select From Other Sources as shown in the screen shot below. Hello Chris, I have tried using this code to change the connection string in my powerpivot enabled excel workbook. When I copy and try to paste as a picture link it is greyed out. From the Connection Properties window, click on the Definition tab. If the connection is in read-only mode the properties will be greyed out, and you. --Excel Connecting to SSAS Tab Cube, Can I Switch to Another Cube, and Not Effect the Existing Report. My approach is fine but what a mission to write a bunch of macros when Excel. I am having issues with not being able to change my background picture because it is grayed out under the display properties. RSLogix 5000 Tips and Tricks. Unprotect Sheets in your Problem File. Clicking the Properties button will open the Query Properties window, which we have already seen in the Data Refresh post. But when I check the file properties, the hidden attribute checkbox is greyed out, so I can't untick it. What you can is to insert document as icon, then remove the icon. To automate connection pool changes for use in a process such as production migration, consider using the Oracle BI Server XML API (11g). You can access the VBA environment in Excel 2016 by opening the Microsoft Visual Basic for Applications window. button is greyed out within the Connection Properties. We have an Excel spreadsheet that uses a Data Connection to a SQL Server database. Open each Power Query data connection, and view Properties. In this step by step tutorial I will show you how to create an Microsoft Query to extract data from either you current Workbook or an external Excel file. I would like to modify the query to use the to date in Table 2. BIOPAC,Applications,Advanced Features. Once you connect your Excel workbook to an external data source, such as a SQL Server database, Access database or another Excel workbook, you can keep the data in your workbook up to date by "refreshing" the link to its source. Hi Linda, It sounds like you may want to leave Excel in compatibility mode when working on your workbooks. I'm using Microsoft Excel 2013 to extract data from SQL Server. Microsoft has just announced today that they have provided a free option to use Azure for your website needs. Well, there are actually two more places where you can click Refresh All in Excel: on the Data tab in the Excel Ribbon and on the Analyze tab you see when working in a pivot table. ll see the new Date Table button enabled. If you look at the delete button in the Access toolbar, it will be grayed out like you can’t use it. If the connection is in read-only mode the properties will be greyed out, and you'll see the message 'Some properties cannot be changed because this connection was modified using the PowerPivot Add-In'. MySQL for Excel provides several options to create and manage MySQL connections. Modifying Data Connection Properties in Excel Adam Gaweda Editing External Data Range Properties Marilyn Hale 4,539 views. Change the size of the table. Dynamic Excel Web Part. To rename an Excel table, first ensure that the Design contextual tab is active, and then, in the Properties group, edit the value in the Table Name field. Now create an ADO connection manager, or ADO. Anyone know how to remove the gray mass so everything is still visible?. Once you connect your Excel workbook to an external data source, such as a SQL Server database, Access database or another Excel workbook, you can keep the data in your workbook up to date by "refreshing" the link to its source. Click on the Tools button and click General Options. First, I went a standard Power Query route and right-clicked on one of the data sets and then clicked Edit. However the connection string I wish to change is greyed out and says "Some properties cannot be changed because this connection was modified using the PowerPivot Add-in". The problem is that the connection string seems to be grayed out. I have an Excel query that pulls from an ODBC connection. Then go to the Power Pivot window and. The query properties are all greyed out and cannot be customized. Today I am going to spend some time trying to convince (and demonstrate to) Excel Power Pivot users that it is easy and valuable to learn some simple SQL code. There were also several interface changes that appeared at the same time as this issue (a new Queries & Connection button/pane). Imagine a Pivot Table pulling information from thousands or millions of data points with hundreds of columns and you being able to share this humongous data set with colleagues using an Excel spreadsheet that weights nothing more than a few Kilobytes. Sometimes we may have an Excel workbook that would be sensitive to changes. In the Create Table prompt box, check My table has headers (if the range do not have headers, uncheck it), click OK button, and the range data has been converted to table. Lets go through each of those steps in more detail to make sure you can break links. Excel 2007, Get External Data is greyed-out. Two of the most popular pasting methods are transposing and linking. Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table. By closing this banner, clicking "Accept" or continuing browsing our site, you consent to the use of cookies. This page will show you how to convert Excel data into a table. I "linked" Excel to Sql and it worked fine - I wrote some SQL script and it worked great. a Contacts list) does work!. You can also access an Excel workbook via ODBC. Good Morning, I have been working with Spotfire for about a year now and this is the third time that this has. I am running the latest version of Excel and have a current Office365 subscription. Create a new connection to SQL Server, then in the Connection Properties dialog. Select this connection and click on the Properties button. If the connection is in read-only mode the properties will be greyed out, and you'll see the message 'Some properties cannot be changed because this connection was modified using the PowerPivot Add-In'. Why can't I add a base map to my data frame in ArcMap? I am using ArcGIS 10. If you have several SQL Worksheets, the order is (open connection, closed connections), but at time of SQL Worksheet creation. Table names are similar to defined names, which makes them easy use in formulas or to select data. So first you open a blank workbook in excel and go to File->Options. I need a quick assistance on this hijackthis log. This wikiHow teaches you how to stop sharing a Microsoft Excel document on desktop, iPhone, and Android platforms. I\'m getting greyed out Options -> Context Option and Edit Report button for the first time, after having used the report successfully without problems for the past few weeks. When I do this, it creates a new pivot table with the new data. How do you turn off workbook sharing in Excel. xls), can you use the native Excel Connection Manager type in SSIS designer to connect to the file? When you create the Connection Manager as an OLE Db, using the MS Access. When I go back in, the password is gone. Add Excel Tables to a Data Model- Instructions: A picture of the "Workbook Connections" dialog box in Excel, showing references to Excel tables in the data model. After you install Microsoft Office December 9, 2014 security updates, the following issues are encountered in the EPM Add-In (10. I\'m getting greyed out Options -> Context Option and Edit Report button for the first time, after having used the report successfully without problems for the past few weeks. X) products: 'Edit Report' is grayed out Context options are grayed out The EPM pane shows no connection fo. You can join data from different areas or worksheets. The problem is that the connection string seems to be grayed out. The press OK. Is the Edit Query button greyed out or is it Parameters? Once the data is in Excel, he clicks Connections, selects the connection and hits Properties, Definition tab, then under Command text is the SQL syntax. Connect to SQL Server Analysis Services Database (Import) Use an existing connection. In step 1 of the Data Connection Wizard, under What kind of data source do you want to connect to, click Other/Advanced, and then click Next. Hi I am new to the site and doing dashboards. Click this. When I do this, it creates a new pivot table with the new data. So I can't make parameter query. A Create PivotTable dialog box appears. Understanding how to use Microsoft Excel files in ArcGIS. Two of the most popular pasting methods are transposing and linking. To learn more about connection managers, see Integration Services (SSIS) Connections. Please refer to the numbers on the screenshots: Click on “From Text/CSV” on the “Data” ribbon in order to start the import process. Click this. Laura asks: I am trying to use one query but with multiple paremeters depending on the cell. While the paths via the. Where are Edit Links and Break Links in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365. The name of a table is used when you refer to cells within the table in a formula. The desktop option. Excel offers many different ways to paste information that you have copied. or External Data Properties from the popup menu. We’re going to import an Excel file called Office Supply Sales Data. There is a known issue with this that sometimes occurs in Excel 2013, where the option to change the maximum number is greyed out. However, the RAM you chose at Newegg the the desktop reolution and concept. if you need to write VBA code to run when the button is clicked, click the View Code button. This wikiHow teaches you how to stop sharing a Microsoft Excel document on desktop, iPhone, and Android platforms. This results in a data connection in the spreadsheet that does the job. Issue: When users will try to export e. Please refer to the numbers on the screenshots: Click on “From Text/CSV” on the “Data” ribbon in order to start the import process. This site uses profiling cookies to improve your online experience. RSLogix 5000 Tips and Tricks. Excel automatically refresh pivot table. Create a PivotTable by using an existing external data connection. Properties group. Under Connection Name, type a name for this connection. xls file that comes with the program has Visual Basic (VB) code embedded within it to make the connection between the workbook and the Refprop DLL. If the Encrypt contents to secure data option is disabled, greyed out or unavailable in Windows 10/8. This listing is for Allen Bradley's RSLogix 5000 software. Default = Yes. I am unable to Edit Excel in Box anymore. So now I am going to share exactly this. Click on ‘ Business Data ‘ under Categories and then click on ‘ Excel Web Access ‘ under Web Parts section. Hi, I am using IE Ver 6. The fact that the type is that, and the connection string is grayed out means that this is a connection for Power Pivot. From the pull-down menu, choose either Automatic or Manual. VBA Editor References Option is Grayed Out. Creating Tables in Excel with VBA and External Data – Part II. xlsm file and the datasource of this file is described in the connection string posted above which I can see from Connection Properties in the excel file. In this popup, select the "Definition" tab and paste your SQL query in the "Command Text" input box. Connecting an Excel Sheet to SharePoint Posted on April 2, 2013 by Andy Dixon — 6 Comments If you were lucky enough to attend the Microsoft SharePoint Heartland conference last month, then you were able to see the keynote speaker Dux Raymond Sy present. Then ensure the “Table” radio button is selected under the “Select how you want to view this data in your workbook” area. This PivotTable can be saved and distributed to users of Excel 2003 and the private calculated member will show up and work. When prompted for the password, enter the password and hit the OK button. However, Excel 2013 now supports the data model by default, and allows data to be imported to it through several approaches. all suptopics on separated slides. Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table. 5 Download. The problem is, when I go to data > connection > properties > parameters is greyed out. MySQL for Excel provides several options to create and manage MySQL connections. And its only when I refresh the data. After displaying the Developer tab, create your value list that you want to add to the combo box. 3 of the online plug-in might exit unexpectedly while disconnecting a session from a Web Interface site with a Microsoft Excel 2007 spreadsheet open. My requirement is to fect the data from oracle database from Excel. 4 This means your purchase is protected from. For the most part, it'll be a couple of simple values, such as start date, end date, and username. The button is not greyed out, it simply does not open anything when pressed. 1 (I think). button is greyed out within the Connection Properties. Issue When I am in the VBA editor for Great Plains, if I click on Tools | References, the selection is not available. Content provided by Microsoft. How to modify or delete calculated fields in Excel pivot tables - posted in Pivot Tables: Hi Guys, Excel 2007, Expert Skills, Lesson 5-14: How to change percentage of bonus after once assigned? And how to remove the bonus once created from pivot tab that appear on the right hand side? Thanks. Query Properties. Select File/New, type a name, and select Universal under Type. Using Stored Procedure as Data Source in Excel 2011-01-04 Pavel Pawlowski Excel , SQL Server Connection , Excel , SQL Server , Stored procedure When you want to use a SQL Server as external data source in excel, you can find, that it is not possible to select a stored procedure as a source of data in the Data Connection Wizard. MySQL Forums Forum List MySql dor Excel doesn't show up connection. Well, there are actually two more places where you can click Refresh All in Excel: on the Data tab in the Excel Ribbon and on the Analyze tab you see when working in a pivot table. In this tip we will learn about. I've tried SFC scannow and it said that the corrupted files has been fixed but the issue still persist. In step 1 of the Data Connection Wizard, under What kind of data source do you want to connect to, click Other/Advanced, and then click Next. Yesterday an Update for Windows 10 was installed and now I noticed that my Properties option on the Right Click Context menu isn't working. Add color, banded rows, and header styles with just one click to style your data. SSIS Excel Source. Now when you return to your pivot table, it should display information from the new data source. [#LA2351]. They will open opnly in IE. When I remove the Table format i can create picture links for the tables individually but not as a group. Right-click the SQL Server Browser and click Properties. just curious how you can do that. I'm using Excel 2010 (if it matters), and I can execute a stored procedure fine - as long as it has no parameters. You need to talk to whoever is managing the overall network to address your question properly. This site uses profiling cookies to improve your online experience. I found out how to go into the "Connection Properties" in Excel and change the Refresh Control settings, but the one that I need the most (Refresh every __ minutes) is greyed out. I am using Excel 2019, 64Bit, with 16 Gigs RAM, but my CPU is getting taxed. In Excel however, the visible property of a worksheet object has three possible values: true, false, or…. ) instead of Excel. Simply right click on the table and select the Edit Query. However, Excel 2013 now supports the data model by default, and allows data to be imported to it through several approaches. 3 that a lot of the fomatting/suppression options are greyed out - I am connecting via HPS using the "Shared Connection" to Essbase sample. How to modify or delete calculated fields in Excel pivot tables - posted in Pivot Tables: Hi Guys, Excel 2007, Expert Skills, Lesson 5-14: How to change percentage of bonus after once assigned? And how to remove the bonus once created from pivot tab that appear on the right hand side? Thanks. Click on the Tools button and click General Options. It is quite simple to link an Access database table or a select type query to an Excel worksheet. If you have several SQL Worksheets, the order is (open connection, closed connections), but at time of SQL Worksheet creation. This is meant to make slicers easier to use with a touch-screen. …Some are text boxes, some are combo boxes and check boxes;…they are visually different. However the connection string I wish to change is greyed out and says "Some properties cannot be changed because this connection was modified using the PowerPivot Add-in". Excel Tables are given default names (Table1, Table2, etc. Step 1 − Click any cell in the Table. 3 that a lot of the fomatting/suppression options are greyed out - I am connecting via HPS using the "Shared Connection" to Essbase sample. I am using Excel 07. I have an issue with MS Query that is causing problems for one end user for whom this has worked in past. Since 1994, Excel and Access, and its portfolio of companies, has been the market leader providing benchmark Microsoft Application solutions. Excel Powerpivot Table Properties Greyed Out. But by mistake, I have selected always export in selected format so now whenever I tried to export data, it will directly export to selected format and not asking me to which format I want to export data. The file name in this example will be based on another variable. I want my excel file to be automatically update when something changes on my Sharepoint list. You can view the PowerPivot connection via Excel > PowerPivot tab > Manage. You can see the connection below along with it's table in the background. Excel will determine the number of parameters from that string once it has been applied to the Connection property and then the Parameters collection becomes available to VBA. Like Jerry, I'd recommend spending some time with the Numbers '09 User Guide. It was fine last. I may have changed a setting yesterday that change this but I checked all again. Typical connection properties are the following: User; Password; AccessToken See the "Getting Started" chapter in the help documentation for a guide to using the ODBC Data Source Administrator to configure the connection to Salesforce. The best way to add the data from Power Query is to select “Only Create Connection” (shown as #1 above), then click “Load” (shown as #2 above). This results in a data connection in the spreadsheet that does the job. When you close and load the query to an Excel table, power query will create a table with the same name as its source query if the table name isn't already taken. Excel will determine the number of parameters from that string once it has been applied to the Connection property and then the Parameters collection becomes available to VBA. Reporting: White Box on Desktop In Upper-Left Corner of Windows XP This post has been flagged and will be reviewed by our staff. Select File/New, type a name, and select Universal under Type. Open the Excel spreadsheet. Instead one has to add all parameters one needs to the Connection string. This also allows workbook merging check box. If we go to properties of that, and go to the Definition tab, we can see the following connection string. First, be sure that the Developer tab is visible in the toolbar in Excel. I cannot access any of the functions. Tip: If you want to sort the bars from the lowest to the highest bar, select Reverse scale after clicking Sort bars by value. In the example below, a web query is added to a worksheet. a Contacts list) does work!. How can I create a System alias? Standard Connection - System connection is grayed out: In-DB Connection - System connection is not an option:. It's easy to tell that the InfoPath form controls have properties, have settings. To view an Excel connection's properties, do one of the following:. These changes may give you a greyed-out SolverStudio editor window, or an editor window showing at a strange location. If the Connection String box is white and looks like you could edit it, then you are OK. First, be sure that the Developer tab is visible in the toolbar in Excel. I am trying to set up a System alias, but the System option is grayed out or missing. TechKnowledge Content Issue When I am in the VBA editor for Great Plains, if I click on. X) and BPC for Excel (7. For connections that are shared in the library, use the Manage Data Connections tool instead. [#LA2351]. Even after a complete new installation of Windows 7 and Office 2003 professional or Office 2007 professional on another computer. My boss wants me to find a way to put in parameters for the file so it doesn't search the entire database every time it's pulled up. by passing the three parameters. Hello Chris, I have tried using this code to change the connection string in my powerpivot enabled excel workbook. You can even get data from the result of a SQL Server SELECT statement into an Excel spreadsheet. --Excel Connecting to SSAS Tab Cube, Can I Switch to Another Cube, and Not Effect the Existing Report. Close and reopen BarTender. I can see a parameter button at the bottom of the definition of the Connection Property window, but it is grayed out. You may have a pivot table that links to data in the same workbook or external data, and you may want to refresh pivot table automatically in order to see the most updated data. Definition tab. If I am on a cell within the "Table", Get external Data options are greyed out for me. but since update every n minute is greyed out under Connections -> Connection Properties Microsoft Excel_2014-09-25_09-56-40. WHERE ([Market] = 'Tulsa')This statement tells Excel to pull in all records from the Sales_By_Employee table where the Market equals Tulsa. Excel 2013: Connection Properties - Definition Tab Click on the "Parameters" button at the bottom (if you have used the SQL Server option in Excel this is where you'd have the problem - "Parameters" would be permanently greyed out);. it is not for the. For example, you can add them to ArcMap, preview them in ArcCatalog, and use them as inputs to geoprocessing tools. Click on ‘ Add a Web Part ‘ link 3. Re-create the connection to the Excel file using the Database Connection Setup dialog. A "Create Table" dialog box will open. To make the formatting 'stick' you need to highlight the cells via the pivot table's own menus. Feel free to add your own tips and tricks using the 'add comment' link. In this tip we will learn about. The main goal of the project is to speed-up your daily tasks as DBA, SQL developer or data miner , additionally protecting you from occasional data or code loss. 3-If I install the drivers at this prompt it tells me that the drivers have been successfully installed. Give a table a name to make it easier to reference in other formulas. Then, on the Review tab, in the Changes group, click Share Workbook. Convert Data Into a Table in Excel. A comprehensive list of defect corrections for Planning Analytics Workspace and Planning Analytics for MS Excel components in Planning Analytics 2. ) when they are created. Hidden When a worksheet has a visible property value of true, it is visible and can be seen and selected by the user. I am using Excel 07. Give a table a name to make it easier to reference in other formulas. Tools group. Even after a complete new installation of Windows 7 and Office 2003 professional or Office 2007 professional on another computer. Excel file connection How to upload xlsx 2016 into MSSQL 2017 using stored procedure in ASP. Query parameters in an external connection to sql server. He has Excel 2010, I only have 2007, so I may be missing something. string 2 and 3 are Dates parameters. Re: Greyed out Table Design by Safway » Fri Dec 12, 2008 1:20 am I have seen this problem before and it seemed to be related to the type of database I was using and possibly if I was using connection pooling. Then ensure the “Table” radio button is selected under the “Select how you want to view this data in your workbook” area. After you export data to Excel 2010 as Dynamic Pivot Table you may have not been able to choose "Data Filters" in the Excel Worksheet - option was greyed out. Thus, you may find them a bit tricky to find. but since update every n minute is greyed out under Connections -> Connection Properties Microsoft Excel_2014-09-25_09-56-40. and there I saw option 'Refresh every x minutes` grayed out. They are a new feature from Excel 2010 onward and Mac for Excel 2016 and a must for anyone wanting to wow their boss by adding interactivity in their reports!. Also try to recreate the connection to test this issue. He has set up a connection to an RSS feed, which he says works fine. I was working in Excel 2010 on a workbook with multiple sheets when I suddenly couldn't interact with the Insert or Data menus (they were entirely greyed out), I also couldn't interact with my PivotCharts at all. 4 As Microsoft makes significant updates to Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. Open a spreadsheet in Excel that contains a working Microsoft Query; Highlight cell A1 (or any cell associated with the query), then the click the Data tab and select "Properties" This will open the External Data Properties window. I go to Design > Table Properties but I don't see Table Preview i. You may need to contact your IT administrator to accomplish this. So still need help. We have a twb file with a data connection that points to a tde fed by an Excel spreadsheet. 1, or 10 The scan button may appear grayed, shaded, or you may receive a message stating: default scanner not attached. Here's one of my favorite tricks for using slicers across multiple Excel PivotTables. However, since upgrading to Excel 2007, Get External Data is greyed-out. Excel Slicers Connected to Multiple Tables. Password field grayed out when trying to connect via BeX Jan 28, 2008 at 06:18 PM | 99 Views Business Explorer SAP Logon screen password is grayed out and user can not type in. The first one is the Excel connection and the second is the PowerPivot Connection. The file has a greyed out "Archive" attribute as the file property. After you export data to Excel 2010 as Dynamic Pivot Table you may have not been able to choose “Data Filters” in the Excel Worksheet – option was greyed out. Once you edit.