• Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,410 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE56,100 pointsBadges:
  • Excel.exe process is getting struck in task manager and it’s not closing even the session is end

    Hi, My code is invoking Excel process to generate the report and that is killing once the process is completed. But sometime, couple of Excel.exe process is getting struck even the session is ended. Which is causing NFS memory full. Please advise me of what the the root cause to this issue is. By...

    FIRSTSCHOOL5 pointsBadges:
  • Excel 2007 – how to add a average formula to that cell/s that ignoring 0%’s

    Okay I figured out how to ignore zero %'s for a graph. Now what I'm stuck on is how to add a average formula to that cell/s This is what I had: =IF(SUM(U171,U122,U74,U27)=0,#N/A,(SUM(U171,U122,U74,U27),(AVERAGE(U171,U122,U74,U27)) Thanks,Jared

    Jreifenstein001185 pointsBadges:
  • RUNSQLSTM and Excel

    Can an Excel spreadsheet be created with the runsqlstm?

    lewman5 pointsBadges:
  • Can I zoom in on a linear graph in Microsoft Excel?

    I'm looking to create a linear graph in Excel to show the difference between three algorithms. However, the differences are smaller compared to their overall values. Because of this, the lines merge and I can't see the small differences. Is there a way in Excel to zoom in on the linear graph so I...

    ITKE56,100 pointsBadges:
  • ODBC Library list

    Dear users, If we are using Excel to get External data from iSeries, can we add a library temporary to a predefined Data source such as we can do during File transfer Properties?

    chalenger455 pointsBadges:
  • Multi-line text from Microsoft Excel without quotes

    I'm creating a multi-line string in an Excel cell by using "Alt-Enter". If you copy that cell to an text editor, Excel automatically adds double quotes around the full string. Cell1 | Simple String 1 Cell2 | First line of a | Multiline string | with 3 lines Cell3 | Another simple line 2 However,...

    ITKE56,100 pointsBadges:
  • Subtracting cells only if they have a value in Excel

    I want to subtract two cells in excel but only if both cells have a value. For instance, the formula I am using is thus: F2 is currently =E2-D2 but I only want this to be calculated when E2 has a value.

    ITKE56,100 pointsBadges:
  • Oracle Reports 6i – Convert data in Microsoft Excel

    How do I convert Oracle Reports 6i data into a Microsoft Excel through coding on button?

    Sskhan35 pointsBadges:
  • Joining two Excel spreadsheets

    I am looking for a way to join two spreadsheets in two different Excel files. They both contain a list of names and addresses. One is a master list that includes other fields, and the other is a list that only includes name and address and an ID column that was pared down by another office.  I...

    ITKE56,100 pointsBadges:
  • Microsoft Excel

    How do you stop Excel from highlighting multiple cells at once when you only click on one? It's really frustrating when doing data entry.

    FHAVEN10 pointsBadges:
  • Is it possible to have Regular Expressions in Excel without VBScript?

    I know this is a longshot I'm looking for a Microsoft Excel function that I could put in a cell to do a "regex" search of content in other cells. I'm looking to stay away from adding VBScript. Is there any other way of doing this?

    ITKE56,100 pointsBadges:
  • Script to extract files information from FTP server

    Hi, I wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will: Log on to a ftp server using a generic account and password It then find the files (no downloading) in a specific folder that begins with...

    Aiko2720 pointsBadges:
  • 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?

    ITKE56,100 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?

    ITKE56,100 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...

    ITKE56,100 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?

    ITKE56,100 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:

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