data tables

  1. F

    Power BI refresh button for certain Data Tables

    I have Power BI file that has 12 data tables: 7 are only refreshed once a month but the other 5 need daily. Is there a way to create a button for just those 5 to refresh? I have been having to either refresh everything or each report individually. Due to the amount of data, doing everything...
  2. P

    Graph help (Data Table)

    Hello experts, I am having difficultly graphing the attached. The original file in excel is a a data table (What If Analysis). link to file is below. <tbody> Price per Chair 500 750 1000 1250 Cost per Chair $200 $15000 52500 90000 127500 $175 $2500 33750 65000 96250 $150...
  3. N

    Click on a pivot chart and get the table data ... Possible?

    Hi, Building a dashboard and displaying lots of charts. However sometimes the use might need to see all the details. The details not displayed on the charts. Is there a way to click on the chart or a column/line on the chat and get back to the full details? FYI - all these charts are tied...
  4. R

    Data table results being converted to values by Excel

    My problem is this: I have several data tables set up in my spreadsheet. For reasons I can not detect (it seems to be happening at random), individual rows within these tables are converting to fixed values. Obviously thereafter the tables do not work as intended. The 'surviving' cells in the...
  5. P

    Referencing the Column (or Row) Input Cell as Part of the Data Table Column (or Row)

    I have a data table where want a column header to refer to the "Column input cell" so that my sensitivity analysis always has the value of that cell as part of the table output. The problem is that whenever I make a column header reference to the input cell, the output is incorrect. Is there a...
  6. T

    Conditional formating/data tables

    I am unsure how to make this formula work for me. The example ia: I have a list of values in A1 that range from 1-25 that can be selected. In B1 i need a formula that will make B1 a certain value based off what number is in A1 Example: A1. B1 1. 1 2. 2...
  7. A

    Categories in Data Tables?

    Hi everyone, So for the sake of an example, say I want to calculate a prices per pound, but there are different colored containers that indicate different prices. Like a red container is $1/pound, a green container is $2/pound and a blue container is $3/pound. So my Data Table would look...
  8. J

    Data Tables (What-if-analysis) with Powerpivot

    Hi, I have an Excel model that uses historical data as one of its inputs. The historical data is voluminous, hence instead of importing into excel and using VLOOKUP (or something similar), i opted to putting the huge database into MS Access, and then import into Powerpivot and using RELATED to...
  9. D

    Override Excel sort with SQL order by statement

    Hello again. I'm currently working on reorganizing a datatable in a fairly complex Excel application. The problem that I'm running into is this: I have an ORDER BY clause in my SQL expression (Microsoft Query via an ODBC connection). SELECT A, B, C, D FROM some tables WHERE some criteria...
  10. J

    Probelms with Corrupted Workboo

    I'm having a problem with a workbook that keeps getting corrupted. Even if I rebuild the file by hand in a new workbook, the problem persists which makes me think it's something wrong with my methodology. I'm running Excel 2013 32bit on Windows 7 64bit. I have a suite of workbooks for tracking...
  11. S

    Data Table Vlookup column Reference

    Good Morning When using an Excel Data Table and Vlookup is it possible to reference the column position in the Table by the column name instead of the column number. I did a literature search at it appears I must still use the column number. Thanks Steve
  12. O

    Is there an excel add-in for table functions?

    Since weeks I am looking for an add in for table valued function but I couldn't find any... Could you recommend me some add ins that can help me to make operation with excel tables?
  13. Z

    Storing and Organizing Data

    I'm setting up a type of form in excel where I have some validated drop down lists and I'm trying to use a macro that will, upon a button click, take the data from the drop down lists that are entered into the boxes, and organize them into a chart on a different sheet of the document. This would...
  14. B

    VBA- Global Databases?

    Hi, I am trying to make a global macro that involves inputting VLOOKUP formulas into cells. The problem is that the data being looked up has to be pasted into a workbook that already has the data tables that need to be referenced. My question is if/how I can make global data ranges that a global...
  15. G

    using a cell reference for data table input

    i feel like i have done this a hundred times, but for whatever reason its not working for me... i have a data table that looks like this: <tbody> RATE Monthly 289.68 1.00% 262.81 2.00% 276.04 3.00% 289.68 4.00% 303.74 5.00% 318.20 6.00% 333.06 </tbody> all the RATE numbers...
  16. A

    Can I identify a specific permutation of responses to a survey and display it?

    I very much appreciate any and all help in accomplishing this objective as follows: I have an online survey which has 9 list box questions. The only options for each question is "A" or "B". When the form is submitted I will have one row with some "9 column permutation" of "A's" and "B's". Each...
  17. W

    Breaking Chart Links Loses Formatting in Chart Data Table

    I create workbooks that have a significant amount of private data that is used to generate charts and reports. We want to distribute a workbook with just the charts and reports without any links to the data. No big deal - use vba - create a new workbook, copy over the charts to the new workbook...
  18. J

    Excel Data Filter Drop Down list

    I have two Excel spreadsheets in this workbook and am using 2007 for development. Sheet1 contains the raw data and sheet2 contains summary information about the data on sheet1. I wish to restrict the user's access to sheet1 but I would like the user to be able to apply filters on the data in...
  19. T

    VBA code for a data table

    Can someone please advise what the VBA code would be for a 2-way and 3-way data table.
  20. G

    Substantial modification of a table - EXCEL 2007

    Hi, I have substantial amount of information which I would like to arrange in the following manner. I did believed I was an 'ok' Excel user, but I have tried this problem with PIVOT tables, with concatenation of IF / HLOOKUP, with very limited success. (and more gray hair) The way I have it...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back