• Setting a slicer in a pivot table

    I need to set a slicer in a pivot table by using VBA so that I can limit a number of filters the user choose. I mean if the user choose, for example, more than tree options in a slicer a warning message box pop up on the screen. This slicer I am talking about is based only in one field on the table.

    bosswt5 pointsBadges:
  • How to get rid of blank areas

    I have a database that contains path diagnoses (rows) and stains (columns) used to determine diagnoses. Therefore for any single entry there may be multiple empty columns. When I make a pivot table I want to be able to show only columns with data in them.

    mensamedic5 pointsBadges:
  • Can I hide columns in Microsoft Excel 2010?

    This might sound like a simple question but I'm trying to figure out how to possibly hide columns in Excel 2010 but still have the values show up in the graph. I have a graph of monthly data going back several years, which each month's data showing up in a specific column. I want to hide all the...

    ITKE342,195 pointsBadges:
  • Microsoft Excel error message

    I have just installed Office 2010 and error message comes up when I start Excel: 'Compile error in hidden module: AutoExecNew' I also get error message when closing Excel: 'Compile error in hidden module: DistMon' Please can you help?

    Sandralord5 pointsBadges:
  • OLE error message

    When I try to open a hyperlink to a password protected word document in Excel, I get the message that Excel is waiting for another application to complete an OLE action.

    nellstar5 pointsBadges:
  • Excel and Works databases both stop responding

    I have an HP Pavilion Laptop running Vista :(   - I've begun having continual problems with databases locking up and not working.  Have Excel 2010. When working with data, the circle spins and then says Excel not responding.  Switched to Works database ... was fine for one day, used it again...

    EntExp5 pointsBadges:
  • Excel 2010 Second drop down based on first, not working

    I have tried a number of different formulas and data validation scenarios but I have not been able to get my second drop down to recognize the choice in the first drop down. I have a chart of sizes (including fractions) and several weights for each size. I want the weights in dropdown 2 to be only...

    jacktal5 pointsBadges:
  • Excel 2010

    The averages in several columns do not include the product in row 4. adjust the functions in these cells so that all products are included in the calculation.

    enforcer310 pointsBadges:
  • AutoRepublish error: Can not access

    I would like to AutoRepublish a excel sheet to a single page web, but generate the error of can not access. Do you know what's the problem?

    JERRY015 pointsBadges:
  • Transfer AS/400 to Excel

    Hi there again, Odd question...I am trying to transfer targets and there are more than a few. My Question: Is it possible to transfer more than on file simultaneously from iSeries to multiple Excel spreadsheets, or does this need to happen one at a time. Trying to cut down the continuous transfer....

    superbru43115 pointsBadges:
  • Special Table Filter

    I have a table (A6:AA2026) where column contains 14 different names. I want to hide column A but have it sort based on the contents of cell K1 (a data validation cell containing a list of the the 14 names in column A). How can I do this?

    boomerspapaw5 pointsBadges:
  • Importing Excel data into SQL Server and filtering columns of Excel data in SQL

    I'm trying to import Excel sheet's data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?

    dammu5 pointsBadges:
  • Macro for multiple worksheets

    I have a couple of macros I want to run on several worksheets in a workbook. I want to make a copy of the worksheet and use the same macro with in a given workbook. I do not want to supply the macros in a separate file if I email the workbook to someone.

    Dan35 pointsBadges:
  • Excel function to identify combination of text and numbers

    I have a list of IDs (for example NSD2015, 751234, 92231J,V1819, GR5007 etc.)and would like to identify those from a list of thousands of IDs (each in a separate row in the same column). Tried VLookup but it appears that only works with values? Getting frustrated and I'm sure this is easy to do......

    topdrawer5 pointsBadges:
  • Calculate overtime in Excel

    Hi All, I need to work out if the time captured in my AmendedDate column falls outside normal business hours. So basically I am reporting for a Call Centre, which logs support tickets. In my Database I already have a created Date (when the Ticket was Issued), AmendedDate (When the technician made...

    BigJoe2350 pointsBadges:
  • Excel 2010 question

    How do I execute fill right, fill down, and simply undo?

    DLemmon5 pointsBadges:
  • EmbeddedPivotChart: Drilldown-Class

    Hi Everyone Let me start off by saying I'm a complete Noob when it comes to this, so I hope my explanation makes sense... I've been trying to implement the Embedded Pivot Chart Drilldown Class as explained by Craig Hatmaker on the YouTube video :http://www.youtube.com/watch?v=-Uu2WqDxLdk Firstly,...

    BigJoe2350 pointsBadges:
  • Sort data in a column, not alphabetical

    I have an Access database that sorts the data in a column alphabetical and I want it to match my Excel spreadsheet which is by area. Where do I go in the database and change it so it follows my spreadsheet?

    DAHurd25 pointsBadges:
  • Having trouble creating a Client Access session using VBA \

    We have numerous Excel Based Interface Macros that Create Client Access sessions, but none will work with Excel 2010.

    Allalb5 pointsBadges:
  • If-then looking for any text in a cell

    This is what I'm trying to do: If cell A has any text in it, then look at cell B and populate cell C based on what is found in cell B.  If cell A is empty, do nothing.  Is it possible? L.

    ExcelBeginner15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following