• Import an attachment (which is embedded in Excel) to Lotus Notes RT field

    Hi, I want to import an attachment that is stored/embedded in an excel sheet. (d:\profile.xls)

    chandrasekarnagilla5 pointsBadges:
  • Microsoft Excel: Count number of distinct values in a range

    In my Microsoft Excel spreadsheet, I already have a large table with several filters. The only other thing I would like to add is a summary (underneath some columns) that contain the number of distinct values for that specific column. Is there a formula / function that would allow me to do that?

    ITKE350,195 pointsBadges:
  • Auto-filling cells in Excel using only keyboard commands

    This issue has me flabbergasted. Here’s the problem. My mouse is broken (yeah I know they’re cheap but I’m trying to get this done quickly) so I’m trying to extend a series by highlighting a group of cells and then clicking on the bottom right corner of the highlighting box and it drag...

    ITKE350,195 pointsBadges:
  • Adding a query into a Microsoft Excel 2007 table

    I have added a query into a Microsoft Excel 2007 table. But, I'm looking to add a parameter from one of the cells into the query. Is there a way to do this?

    ITKE350,195 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...

    ITKE350,195 pointsBadges:
  • Privacy warning in Microsoft Excel 2007

    When I'm tried to save a spreadsheet in Microsoft Excel 2007, I often get this "privacy warning" message. This happens with both macro and on-macro spreadsheets. Is there any way to get rid of this message?

    ITKE350,195 pointsBadges:
  • VBA code to transfer data from iSeries to Excel

    Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...

    Mblair.au25 pointsBadges:
  • How to remove password from an Excel document?

    I’m in a bit of a pickle. One of our less capable clients managed to password-protect on excel file by accident. Of course, he doesn’t know what he did or what the password could be. The password login occurs after Excel opens but before any of the data fills in. Is there a way to remove the...

    ITKE350,195 pointsBadges:
  • Transfer of data from AS/400 DDS Described file to Excel spreadsheet

    I have a critical problem in AS/400 data fetch query in MS Excel (Petch SP2 loaded). I have created several Excel Sheets (in MS Office 2003) for fetching the data from AS400 using MS Office Query option under Data-->> Refresh Menu. Those excel sheets are using by so many different users on...

    Skm200520 pointsBadges:
  • Automatically refresh data from AS/400 DDS Described file to Excel spreadsheet

    Hi, Is there an easy way to automatically "refresh" the data in an excel spreadsheet from an AS/400 DDS Described Data file? I'd like the data to be collected whenever someone opens the spreadsheet. I can already get the data using a transfer request, but I have to start the request manually. I've...

    Gilly40023,730 pointsBadges:
  • Microsoft Excel is displaying ### for long text

    I've hit a crossroads. I have a long Microsoft Excel spreadsheet with long text in just one cell. Instead of line breaks, I keep getting these symbols "####." What can I do to get rid of these symbols?

    ITKE350,195 pointsBadges:
  • Is there a way to auto-refresh an Excel auto-filter when the data is changed?

    Is there a way to change the value of a cell so that when it is filtered, the current row disappears?

    ITKE350,195 pointsBadges:
  • convert oracle reports to excel

    How do i corvert oracle reports to excel

    DDPORACLECORV5 pointsBadges:
  • Excel Macro to extract substrings from a comma-separated string.

    How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

    Sdsdsd15 pointsBadges:
  • Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?

    Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...

    Kaylee5 pointsBadges:
  • Oracle Forms to MS Excel

    I have several reports which extract data via Oracle Forms into MS Excel. But Excel cuts off the input at row 999.  The Oracle Form uses the DDE.EXECUTE(ConvID) command.  Does anybody know if Excel has a limitation of the number of rows it will import via Oracle Forms?

    Mayac35 pointsBadges:
  • Export multiple files to Excel using CL

    Hello, I have these queries on a job schedule now and I want to export them to Excel using CL. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two files to? And can I run both queries this way?

    Querys100 pointsBadges:
  • Problem with shortcut error messages

    I was moving folders around in my documents when something I did erased or moved some of my folders. The documents were Excel spreadsheets with formulas. I ran a search and a couple of them came up but when I click on them, I get the error message: Problem with shortcut the item " " that this...

    Mh1125775 pointsBadges:
  • Can I find an Excel merged cell size in VBScript?

    I have a set of Excel spreadsheets which all have similar properties and I'm trying to automate a set of processes on them. I'm a compelte VB beginner, but it's going ok - I've just hit a stumbling block with the internet isn't being very helpful with. Once I have found a certain cell, is it...

    Bengreen15 pointsBadges:
  • Put rows in numerical order

    I have data entered randomly and now I want to sort it numerically using a certain column as the numbers to sort.

    Kooka5 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