Change Data Source Grayed Out Excel

Wifi is Greyed out (Wifi is Grayed out) It will come back on intermittently / at random and then drop out for long periods. How do I turn this function back on? I have no issues editing them from the other sheets to this sheet but can't from this one sheet to the others. You need the original Excel data sheet to change the legend. For example, you can expand the source data to include more rows of data. Following is a list with the content of this article. I can add a new row of data by: Sub Append. Specify the default database, various ANSI options to be used by the driver, and the name of a mirror server. It didn't help my ability to select the file as mail merge source though. I want my excel file to be automatically update when something changes on my Sharepoint list. How to locate and change the source data for an Excel pivot table. If I am on a cell within the "Table", Get external Data options are greyed out for me. As you can see in a tabular model the option to display these items is grayed out. You can connect to a Microsoft Excel data source by using Excel ODBC driver. I would like it to refresh every 60 minutes. I'm attempting to follow these directions: Refresh Data Using Saved Credentials in order to keep a live connection between a csv saved to Dropbox and my published workbook, but "Edit Connection" is greyed out when I click on the actions menu. Change options, to save source data with pivot table file. The pivots are referencing a tab in the Table/Range in the Change Data Source drop-down that is not visible. You'll then use the connection to analyse data within the database. However this change is bigger than these new functions, it’s a fundamental shift in how Excel (and Excel users) think about formulas. Note that when 'track changes' option is enabled in Excel, the workbook is shared and some of the features are automatically disabled. It is being saved every month in a subsequent folder, attributed to a month (i. We can change the Data. Here, you can verify which part of the current connection path you want to replace with the new connection path. Select any cell within the Cost Centre table. Business Objects has a rule that only non-merged objects from a single data source may be displayed in a table (or block) of data. QlikView is a data analysis tool from QlikTech. Ask your project administrator to change your role to one with a higher level of access. Click in any part of the pivot table and then click the “Options” tab in the ribbon. However, sometimes Excel will not understand what you are trying to do, and will label your data in a different way than you desired. xls spreadsheet to no. I need to edit the connection string, as I intend to use the pbix-file on various customers sql server. If I am on a cell within the "Table", Get external Data options are greyed out for me. Once the cube has fed itself with the data points that it needs, it can act as a standalone data source. (because of a change in data perhaps). Just change this to None and click OK. This is something that needs to be specified by you. To make the sheet visible again, click on any of the remaining tabs and click on “Unhide…” Of course, if no tabs are hidden this option will be greyed out (unavailable). i face the same problem now and then when i have to change the data source for an existing Excel Report. What other ways do you creatively get data into Excel from SQL data sources. Actually, regarding to paragraph 7. All Answers. txt , so that' no more a time save that just chaning to txt and then doing a command o Re: Excel wont open. So far, we have only used the default option which loads the output of the query into a new worksheet. How did they do this. How to change data souce for existing Discovery report Unable to change data source by edit data source feature Files got grayed out and cannot change the source excel file SAP Knowledge Base Article - Preview. My issue remains that whether I have added mail merge fields that match the column headers in my source or not, when I try to link the data source Numbers spreadsheet to the Pages file, that Numbers file and every other file is "grayed out" Thanks though!. An alternative could be to change the table name to the name the pivot table is expecting. This also works well. Data source doesnot get enabled even if you rename the file( save to Pwer Bi report server with a different name). Until now, if I wanted to see the SourceData for a PivotTable, I would use Alt, J, T, I, D to activate the Ribbon control for changing the source data (PivotTable Tools - Options - Change Data Source - Change Data Source). On the Ribbon, under the PivotTable Tools tab, click the Analyze tab (in Excel 2010, click the Options tab). 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. Jet Reports Help 6 3. Re-open the items you'd like to edit or re-open the sprint they were. How-to Connect Excel to an External Data Source June 30, 2011 Jim Merrell 5 Comments For quick and dirty SQL reports, it's hard to beat dedicated tools such as WinSQL , SQuirrel SQL , or AQT. 2017/November, 2017/December etc. Start Excel and open a new blank workbook. Hi Sathyanarayanamoorthy Many thanks for your response and the sample you provided but I still have a problem: your sample uses in-memory lists whereas my source is a database with various tables many of which are linked. Once in Backstage View , from the left of the drop down menu we select the category Options as shown in the image below. You can connect to a Microsoft Excel data source by using Excel ODBC driver. The pivot table links will not update and I am not able to change the data source or update the links. Click and drag in the worksheet to select the new data range. Previously, many of us created multiple worksheets for our various data sources. When you try to refresh the pivot table data, Excel can't find the data because it's referring to the wrong/incorrect table name. This can be set manually in the VBA Editor or by using VBA code. If you choose the 'other data sources/SQL Server' option, you have to edit the query in the 'command text' box below the connection string box. your database is moved to a different server. The Data Model feature lets you create a basic relational database structure within Excel. THe save button is grayed out so I cannot save the document to my computer. Excel 2016: Creating Charts and Diagrams In Excel 2016, charts and diagrams can show trends, averages, high and low points, and more. But I think it's over kill for this type of scenario. Since the purpose of the Data Gateway is to remove refreshes from an individual's machine and put it on the network, I had to change my Excel File's source from the location on my computer to the location on my company's server. Convert Data Into a Table in Excel. 3 Ways to Perform an Excel SQL Query properties will no longer be grayed out like it normally is. As you can see in a tabular model the option to display these items is grayed out. To make the sheet visible again, click on any of the remaining tabs and click on “Unhide…” Of course, if no tabs are hidden this option will be greyed out (unavailable). I am very happy to be writing this blog post today. ' You can merge multiple copies of the workbook by pressing 'Shift' while you are selecting the various workbooks. I would like it to refresh every 60 minutes. If you have chronological data, you can directly access the labels. This should be a simple thing to do through the menu with "edit link" and "Change source" but the "Change Source" button is greyed out and can't be used. Also I wonder in the scenes process for each report execution detailed in the documentation. and the connection string is grayed out means that this is a connection for Power Pivot. The importet Data model, created in Power Pivot, works fine in Power BI Desktop, but the connection string is grayed out under Data source settings. In Dynamics CRM 2011, sometimes we need to export data to an Excel file as Dynamic Pivot Table. Change options, to save source data with pivot table file. This post looks at manipulating an existing table. However, since upgrading to Excel 2007, Get External Data is greyed-out. “Keep in mind that once you have chosen a data source there is no support to change to another data source type without rebuilding the connection which also will force you to rebuild the report and data models”. Try Saving the excel file to a. Once I do that, regardless of whether it's a favorite/shared, I can go to the Add-Ins ribbon, Hyperion->Ad Hoc Analysis->Change Alias Table. What other ways do you creatively get data into Excel from SQL data sources. The options to Cut, Copy, and Paste where disabled - aka 'greyed out' - in the menus. In the Data group, click on Change Data Source button and select "Change Data Source" from the popup menu. Excel displays the Select Data Source dialog box. After you create a chart from a pivot table, the source data setting is locked, and you can't make changes to it. ), you will have to configure it manually. This function appears to be greyed out on all the joins. From the Data source combo box, select the data provider that will connect to the data source. Hi jtillinghast,. If you have no filters applied, but still have greyed out buttons then they represent data you used to have in your PivotTable source data that is no longer be. Calculated Field Definition Microsoft Definition: A Calculated Field is a user-defined field in a PivotTable that can perform calculations using the contents of other fields in the PivotTable. If an Excel sheet has data that won't fit one page across, you can change the Scaling setting, to force it to fit. “Keep in mind that once you have chosen a data source there is no support to change to another data source type without rebuilding the connection which also will force you to rebuild the report and data models”. Select your pivot table and go to the Analyze tab and press the Change Data Source button then select Change Data Source from the menu. x : Change source option is disabled in Web Intelligence when data source is Excel. Hiding / Unhiding a sheet – the basics. However, that option is greyed out and I can't select the data source. I have Excel 2007, and the workbook/worksheet is not protected. Data Validation Greyed out I've inherited a spreadsheet and want to add some data validation to range of cells. One of the other key benefits of Power Pivot for Excel is the ability to easily import data from multiple sources. These are the common reasons for Excel Insert button greyed out on the Developer Tab and the solutions to the same. If this is the case, you will notice that more than one sheet is active at the bottom of the screen. Re: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016 Post by gillyd123 » Sat Dec 03, 2016 11:23 pm Just to add to the mix, since I've been importing Excel data - it crashes Excel. All Answers. However, there is a way we can do that in the primary data source. 2 video - One Click Check In or. I\'m using 1. It seems like the "Change Data Source" feature of Pivot Tables is disabled in Excel 2013 when they are built on the Data Model (PowerPivot). Moreover the data source of this webi document wasn't changed. How to change data souce for existing Discovery report Unable to change data source by edit data source feature Files got grayed out and cannot change the source excel file SAP Knowledge Base Article - Preview. In the "Data" ribbon "Connections" tab the "Edit Links" option is greyed out. Have you ever seen a greyed-out invoice option on a Project Sales Order in Dynamics AX? I ran across this predicament while at a customer site. On the Excel Data Ribbon, in the “Queries & Connections” group, properties will no longer be grayed out like it normally is. You will notice that some of the options in the ribbon are grayed out. Not just because I will be showing you another way Excel can make your data analysis easier but also because I will be introducing the new Data Model and Relationships features that will hopefully change the way you use Excel for data analysis forever. Still I don't see my entry. Click the series name. On the Excel Data Ribbon, in the "Queries & Connections" group, properties will no longer be grayed out like it normally is. Kate Phelps, owner of Taylor Reporting Solutions, helps your sales teams use REPS more effectively and helps managers get all the information they need to make smart decisions. Tableau has a great little feature that allows you to change all worksheets and dashboards in a workbook at once so that they use a different data source. Voila! That's it, you're done. NOTE: For macros that help manage the source data, go to the pivot table source data macros page. I am trying to learn building SSAS tabular model. The Jet Excel add-in can connect to a wide variety of data sources - including SQL databases. Open the Excel spreadsheet. ), you will have to configure it manually. When you open datasets you cannot change values or the data type because of read access. Select all the data links you’d like to kill. Engagement 7. This is the list that we want to populate with data. Click the drop down arrow under 'Allow' and select 'List. How to Fix Excel Sort and Filter Icon Grayed Out. I have a source file that I am getting every month with the updated data. Select any cell within the Cost Centre table. You will notice that some of the options in the ribbon are grayed out. Also I wonder in the scenes process for each report execution detailed in the documentation. From the PowerPivot Data Connections list select your existing connection that you would like to modify and click on the Edit button. Change source option is greyed in Web Intelligence when data source is Excel SAP Knowledge Base Article - Preview 2171411 - BI 4. Excel 2016 - This value doesn't match the data validation restrictions defined for this cell. Use Microsoft Forms to collect data right into your Excel file This post is the first of a few where we look at how easy the Office 365 stack integrates. I have a source file that I am getting every month with the updated data. Data Validation Greyed out I've inherited a spreadsheet and want to add some data validation to range of cells. PowerPoint: Where's My Chart Data? Posted on March 17, 2011 by Veronica Mount Excel Charts are prime examples of the old saying "A picture is worth a thousand words," and PowerPoint presentations provide a great vehicle for passing a chart's message on to an audience. When he right-clicked on the worksheet tabs, the Unhide command was greyed out. To do this we need to go into the PivotTable Options and look at the Data tab. The Coffee Chain data is an Access database, and Tableau uses Microsoft JET for the driver for Access, Excel, and text files (this will change somewhat in 8. I cannot find any information relating to Excel 2010 or greater that explains how to activate this option. Though there is no way to disable copy/paste shortcuts (other than by using VBA), you can at least prevent copying data by dragging and dropping cells. Seems like an odd condition. My worksheet is linked to an external data source using ODBC drivers. For data that is displayed in Oracle after using a query function (e. Hi, Someone has passed me a workbook containing a chart sheet with a standard Bar chart sheet. 0 Details of the APARs listed below can be accessed by clicking the link for the APAR number. When collaborating on an Excel workbook, you may want to keep track of the changes that have been made to it. When Import Data is grayed, two other options - Edit Query and Data Range Properties become. Data validation in Excel is designed to prohibit typing invalid data directly in a cell, but it cannot stop users from copying invalid data. In the popup – you’ll see another properties icon. Let’s quickly build a pivot table that shows total sales and order count by product. A "Create Table" dialog box will open. I can't edit the query anymore because the Get External Data buttons are grayed out. This is easily performed by checking the relevant check box in the Create PivotTable dialog box, as seen below. A search on the web did not come up with an answer; the problem occurs in Excel 2003 & 2007. Flexible reporting tools, fast analytics dashboards, and controlled budgeting solutions Inside of Excel and on the web. I searched that I can use other sources as my data source. The app provides: • 3 chart types. Change source option is greyed in Web Intelligence when data source is Excel SAP Knowledge Base Article - Preview 2171411 - BI 4. any ideas would be helpful. FoxPro, SQL Server, Oracle, etc. In the "Data" ribbon "Connections" tab the "Edit Links" option is greyed out. One of the reasons for this option is grayed out or disabled is because "Display options for this workbook For objects, show:" must be set as "Nothing (hide objects)" instead of "All" How to Enable Display options: Once you change or Enable Display options to "All" Insert Button will be enabled. Business Objects has a rule that only non-merged objects from a single data source may be displayed in a table (or block) of data. In the Create a Data Model in Excel web page, Microsoft describes a Data Model as "a new approach for integrating data from multiple tables, effectively building a relational data source inside an Excel workbook. This still happens if I delete around 50 of my attributes. This post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. I have been unable to find any way to get around this. To use a different Microsoft Office Excel table or cell range, click Select a table or range, and then enter the first cell in the Table/Range text. If I am on a cell within the "Table", Get external Data options are greyed out for me. This video lesson demonstrates how to import data from an external data source in Excel 2013. A user may be defined as an individual Active Directory user or Active Directory group. If the “Edit Links” button is not greyed out it means that there is at least one active link to another data source (usually another workbook). (You can opt out at any time) Data Prep with Text and Excel Files. Select Insert Slicer. 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. Don’t Delete a Table directly in the PowerPivot window. An alternative could be to change the table name to the name the pivot table is expecting. xls) format. See image below. xls is loaded. I added a form control checkbox using the developer tab, but the Move and size with cells option is greyed out. If you choose custom, the Data field is greyed out and you are given a Formula field. However upon checking and try to change the data source from "select a table or range" to "use an external data source" it is greyed out and won't allow me to change it to external data source. What are the functions of the macros?. To change the Protected view setting, you need to make the change in each Office application. Forecast Data (Forecast > External Sources > Upload Forecast Data > Build Forecast Data template) Excel Integration (Forecast > External Sources > Excel Launch > Build Excel Template) When you select one of these options, the system will switch to Excel (or launch Excel if it is not already open) and then display the data you are exporting. /Insert /Caption will be grayed out until a captionable item is selected. A user may be defined as an individual Active Directory user or Active Directory group. If your data is from linked tables in the Excel Workbook, by default these are refreshed automatically when the data changes. Re: Edit "source data" on pivot chart Thanks, I understand that to be the situation (and the problem), I was just curious as to why it can't be "unlinked"? If you can change the source data (i. Once the link has been defined, the data is saved on the worksheet and can be refreshed periodically or on demand. (The "update values" and "change source" buttons are also grayed out, but that isn't. Still I am facing the same issue. The data can come from a database, an HTTP XML feed, a Web service, an Oracle BI Analysis, an OLAP cube, an LDAP server, or a previously generated XML file or Microsoft Excel file. Our goal is to change the x-axis so that you can delete the x values and replace them with the new values. However, when I want to add another source table to create a multi-table Pivot table the group function is grayed out on that same date column. Once I do that, regardless of whether it's a favorite/shared, I can go to the Add-Ins ribbon, Hyperion->Ad Hoc Analysis->Change Alias Table. allow me to change it, it is currently greyed out and does nothing. Click on Break Link. Here you will see an item that says "Retain items deleted from the data source" with a combobox for you to set the number of items to retain per field: By default it's in automatic. I can't edit the query anymore because the Get External Data buttons are grayed out. The favorite/shared setting is only required if you want to use Connection Manager to change alias tables. 2 – Set up data source. On the Ribbon, under the PivotTable Tools tab, click the Analyze tab (in Excel 2010, click the Options tab). To remove/break the link, simply select the rows you wish to remove and click the Break Link button. All images, original file, and data source file are in the same folder. Everything is greyed out and cannot be changed. Awesome 30 Illustration Excel Pivot Chart Data Range Greyed Out interact with the insert or data menus date excel 2010 change data source of pivot table from. An alternative could be to change the table name to the name the pivot table is expecting. Unable to remove “Run this program as an administrator” (greyed out) with Excel 2010. Help! That's exactly what I felt like in this situation. I have checked the file to make sure that it is not read only. (Thinking it was the chip solder problem). Each column has a data type icon on the left hand of the column heading. The invoice button was greyed-out like the screen below. Word 2010: Excel chart "edit" button greyed out - posted in Business Applications: Hey there. If you choose the 'other data sources/SQL Server' option, you have to edit the query in the 'command text' box below the connection string box. a) When the active sheet is protected and you try to edit links the BREAK LINK button will be grayed out. Engagement 7. Instead, multiple Power View worksheets can be created within a single Excel workbook. Excel Services data refresh does not return updated data from data source. Then, you add that same path to the Data Gateway as a data source. table grey next calculated field greyed out in pivot table how to chart in excel combo chart in excel chart excel x pivot tables archives excel campus excel 2013 calculated field grayed out excel 2010 tab how to find source data for a pivot table in excel excel 2010 pivot table wizard gotrekking club. I had an occasion to do this just the other day, in fact. However, we need to add this data source to the Data Model. After creating a chart in Excel 2010, you may need to change the range of the source data that is the basis for the chart. , Query Find), Oracle's Export feature may be used. I am unable to tick the show items with no data option and I don't understand what it's grayed out. The problem is now, when I try to change the data source ("select data source" --> "chart data range") I see that the input field is greyed out. could you please let me know the issue in which cases it effects. 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. Select one of the following options to log on to the data source:. A default blend is equivalent to a left outer join. Excel 2016: Creating Charts and Diagrams In Excel 2016, charts and diagrams can show trends, averages, high and low points, and more. If you choose custom, the Data field is greyed out and you are given a Formula field. Set the Keep your data up to date slider to On to configure the settings. Rather than trying to troubleshoot you Collation problem lets see if we can fix this another way. FoxPro, SQL Server, Oracle, etc. The app provides: • 3 chart types. table grey next calculated field greyed out in pivot table how to chart in excel combo chart in excel chart excel x pivot tables archives excel campus excel 2013 calculated field grayed out excel 2010 tab how to find source data for a pivot table in excel excel 2010 pivot table wizard gotrekking club. Excel columns greyed out. You can edit some items, but not all. This should be a simple thing to do through the menu with "edit link" and "Change source" but the "Change Source" button is greyed out and can't be used. 3 microsoft analysis for office version,having an issue under insert tab--select data source and insert analysis view options are greyed out. Sort and filter grayed out - posted in General Excel Problems and Solutions: I am trying to sort a mailing list alphabetically and when I select the last name column the sort and filter are grayed out and I cannot get it to sort alphabetically. Hiding / Unhiding a sheet – the basics. The formula must yield a TRUE or FALSE result. I often get asked whether this limit of 1000 rows is configurable – well the good news is yes it is. Our organization is rolling out a few tools for Data Loss Protection. Chart x axis scale editing greyed out (View topic) • Apache OpenOffice Community Forum. “Keep in mind that once you have chosen a data source there is no support to change to another data source type without rebuilding the connection which also will force you to rebuild the report and data models”. 1 Not able to change data source type in Power BI report, there is a workaround for this. 1 Overview of Setting Up Data Sources. While following a tutorial I need to add a column to an existing table but for some reason the ADD Column option (insert column in other menu is also not appearing) is greyed out. Excel Lookup Functions Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel When you want to look up data in Excel, you should never use a worksheet function with "lookup" in its name. Fixing ‘Compatibility Mode grayed out’ or ‘Unable to enable Run as administrator’ on Vista / Windows 2008 Server Published April 27, 2009 | By Corelan Team (corelanc0d3r) Ever wondered how you can set Compatibility Mode on executables under Vista / Windows 2008 server when the settings (or even the entire tab) has been disabled ?. Add this data to the Data Model check box is greyed out in Excel 2016 by Wim · 12/02/2016 A problem I ran into when creating a new query in my freshly installed Microsoft Excel 2016 was that I could not import data to the Data Model. Control Panel > System Properties > Advanced > User Profiles > Select User > Delete Login with that specific user to rebuild the profile. Turn data into insights. The Data Model feature lets you create a basic relational database structure within Excel. A "Create Table" dialog box will open. Must match with your Power BI Desktop Data Source setting. However, sometimes Excel will not understand what you are trying to do, and will label your data in a different way than you desired. Data validation in Excel is designed to prohibit typing invalid data directly in a cell, but it cannot stop users from copying invalid data. You can connect to a Microsoft Excel data source by using Excel ODBC driver. and the connection string is grayed out means that this is a connection for Power Pivot. If you choose custom, the Data field is greyed out and you are given a Formula field. xls files in Excel 2010 and later can cause other features, such as Slicers, to be disabled, and will cause charts and pivot tables to take on the Excel 2003 look-and-feel. Excel Services data refresh does not return updated data from data source. In the Manage box, select Excel Add-ins and then click Go. However unlike with a sheet embedded chart object I can't change the source data since the option is greyed out. To remove/break the link, simply select the rows you wish to remove and click the Break Link button. Please be careful: all cells referring to other workbooks within formulas will be changed to values. Data Source isn't registered in Power BI. csv files, is this normal?. The reason this distinction makes a big difference in the file size is because the data model uses xVelocity compression. On the Options tab, in the Data group, click Change Data Source, and then click Change Data Source. Extensible markup language (XML) is a common format for working with data. or in Excel 2013: Excel 2013 - The value you entered is not valid. And the cells have been greyed out based on another column values. PowerPoint: Where’s My Chart Data? Posted on March 17, 2011 by Veronica Mount Excel Charts are prime examples of the old saying “A picture is worth a thousand words,” and PowerPoint presentations provide a great vehicle for passing a chart’s message on to an audience. This can happen when you receive a file from someone else, or if you download data from a source system and try and create it directly in the downloaded file. Click the drop down arrow under 'Allow' and select 'List. Select the Properties button. I'm guessing one of your pivot tables is filtered in some way. I added a form control checkbox using the developer tab, but the Move and size with cells option is greyed out. ) When I recorded the power query, in Advanced Editor it recorded the path which contains that month (i. 1 Not able to change data source type in Power BI report, there is a workaround for this. I then defined a Pivot Table from the data model using the same fields as before. One of the other key benefits of Power Pivot for Excel is the ability to easily import data from multiple sources. Our organization is rolling out a few tools for Data Loss Protection. Data Validation Greyed out I've inherited a spreadsheet and want to add some data validation to range of cells. Greyed out buttons in your Slicer represent data that is not present in the PivotTable at the current filter level. What it does figure out by itself is which data points are increases and which ones decreases. Click the drop-down arrow where you want to add a filter. When, in Power Query, you define a New Source, you select Salesforce Objects or Salesforce Reports. Under the Horizontal Axis Labels section (on the right) the Edit button is greyed out. The other (non-applicable) custom range(s) will be grayed out. The Select Data Source dialog box enables you to choose a different source range for an existing chart. now when i want to change anything in the connections properties it is grayed out. Open Excel, select Jet/Data Sources. Notice in the right window you'll find the PivotTable Field List pane, which contains a list of all your database objects, including tables, columns, and measures. Replacing a Tableau Data Source Tableau Data Microsoft Access Microsoft Excel The data source will be replaced in all worksheets and dashboards. Importing from an MS Excel worksheet. What to do? How can I get around this?. Excel is launched and opens to a new pivot table that automatically connects to the SSAS tabular data source. I'm not sure what 'wipes out all the formatting' means. An alternative could be to change the table name to the name the pivot table is expecting. Managing data coming from various sources lies at the core of Power BI. , Query Find), Oracle's Export feature may be used. Engagement 7. • 7 themes for each type. Navigation in Analysis for Microsoft Excel. I am unable to tick the show items with no data option and I don't understand what it's grayed out. THe save button is grayed out so I cannot save the document to my computer. Environment. However, the new on which I restored from a back up of the iphone 7 on my computer has the greyed out Apple ID,icloud, itunes etc in setting. Change source option is greyed in Web Intelligence when data source is Excel SAP Knowledge Base Article - Preview 2171411 - BI 4. Note In Microsoft Office Excel 2007, click From Other Source in the Get External Data group on the Data tab, and then click From Data Connection Wizard. Go to the 'Settings' tab. I import the Excel workbook via Import > Excell workbook contents. Even though you’re using Excel 2010 and later, the Sparklines command is not available when the active workbook is saved in the Excel 97-2003 (. Then click next to provide connection info. If this is the case, you may need to change the sorting options within the query itself or copy and paste the data elsewhere so that it is no longer connected to another data source. How can I turn it on?. This function works across workbook as long as source and target workbooks are open at the same time. I tried to change the data source of that chart to a different pivot table and if I read your comment correctly, Excel 2010 should have allowed me to select the data source range. Help is much appriciated. The data transfer upload tools require these files so that they can parse the source data file into columns and rows and know what their type and size are. Follow these simple steps to insert calculated field in a pivot table. A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, “pivot”/change the report layout with the ease of dragging fields around, highlight key information to management and include Charts & Slicers for your monthly. Just change this to None and click OK. Still I am facing the same issue. In the Data group, click on Change Data Source button and select "Change Data Source" from the popup menu.