• CVTPFXLS command options

    Hi people, I need some help with formatting Excel spreadsheets within the IFS. My program currently prepares a physical file on the iSeries and uses the CVTPFXLS command to create a Excel sheet. However, this sheet is pretty bland and I wish to add some formatting before the user gets it. The...

    tjgm88995 pointsBadges:
  • Creating a chart for alphabetic data and date ranges

    I am trying to put together a chart that reflects application deadlines for roughly two dozen clients for the company I work for. Some of these clients have two or three different deadlines to reflect the multiple testing windows these clients have throughout the year. Essentially, I am trying to...

    dharvey111315 pointsBadges:
  • How do I remove rows from an Excel page

    I have an Excel spread sheet with a lot of data. However, between the rows with the data there are many rows that are empty. I want to remove the rows to make the data more compact looking. How do I remove them? There are too many pages for me to take the time to delete them one by one. Can anyone...

    Barrymore10 pointsBadges:
  • Which drive is Microsoft Excel located in?

    Microsoft Excel should be located on the computer C drive (the computer hard drive). The computer comes with Microsoft Windows 7 64 bit and Microsoft Office Starter 2010(preloaded). Why can't the accounting product I am trying to set up locate any Excel templates?

    Learning050 pointsBadges:
  • Chart drilldown for multiple Axis field pivotchart

    The solution that Hatmaker shared in this forum to drill down on a pivot chart created from a pivot table works fantastically. I was so happy to find it and got it working for my pivot chart which has one Axis field and one Legend field. However when I added another Axis field to that chart, the...

    RunningDog15 pointsBadges:
  • Microsoft Office Starter Excel

    The Accounting software I want to set up is Excel based enabling the production of Statutory Accounts. It is called VT Accounts. It runs on Excel 32 bit for Windows desktop. So far I have not been able to set it up. Is it because I am running Microsoft Office Starter2010? Do I need a full version...

    Learning050 pointsBadges:
  • Microsoft Excel 32 bit

    I am running on Window 7 Home Premium. I am having trouble installing an Accounting software which runs only on Microsoft Excel 32 bit. Everytime I download the software the system is telling me it can not find a folder with Excel, that I have to select a folder which contains Excel 32. How do I do...

    Learning050 pointsBadges:
  • Download software

    How can I download a program which only runs on Microsoft Excel 32 bit when my current operating system is running on Windows Home Premium 7 64bit?

    Learning050 pointsBadges:
  • Filters

    How do you remove the filter arrows from an Excel table?

    ericanjung5 pointsBadges:
  • How to assign a numerical value to a word in Excel

    I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I can write the simple equation in the cost column to...

    Dontgetit105 pointsBadges:
  • How to protect an Excel sheet from printing?

    How can I protect my Excel sheet from printing so that if anyone tries printing it, they're not able to get a printout?

    Jaideep Khanduja9,385 pointsBadges:
  • Excel

    How do I find the sum in an Excel spreadsheet?

    Keteleyne1215 pointsBadges:
  • Why does Excel keep crashing?

    I have a relatively small file used for work. It contains 20 worksheets (most have very little information, or none at all, which all work fine except for one of them. It WAS working fine, but now every time I try to add or delete a row (which I have to do often) Excel 'encounters an error and...

    ATCPurdue65 pointsBadges:
  • Sheet protection

    My spreadsheet is "read only" accessed by others in my business. Certain columns are locked. I'd like users to be able to copy and insert new copied rows, but when the sheet is protected copy and insert copied rows is not allowed. How do I allow this when sheet is protected?

    jksdr86035 pointsBadges:
  • Creating tools to perform some actions

    I need to check for blank lines occurred in Excel file, if so I need to filter and check the associated name then send them a reply to update for that blank line which is taking so much time so wants to automate this task. Kindly help.

    okok20 pointsBadges:
  • Find and replace text in PPT

    I have a project to find and replace words in PowerPoint from Excel and then save the PowerPoint. My code is working fine. But when PPT has mp3 then it giving errors. Please see the code and tell me what change I should do. Sub pptopen()Dim a AsIntegerFor a =2To4Dim pptApp As PowerPoint.Application...

    fattahaabdul5 pointsBadges:
  • Productivity

    Your team consists of 10 agents, each agent takes 18 calls per day and the average handling time for troubleshooting calls is 90 minutes and the average handling time for transfer calls is 6 minutes and 10 minutes for information calls. The floor averages on the of calls are as follows...

    Haotamsy268015 pointsBadges:
  • Embedding linked Excel into PDF

    Can an Excel file linked from a PDF be embedded in that PDF to deliver 1 file instead of 2? Alternatives?

    EY135 pointsBadges:
  • User prompted for AS/400 log on when using Excel Add-in to upload data.

    I have users that are uploading data to the AS/400 (V6R1) using the Excel Add-in. One user gets a log on pop up window each time she initiates the data transfer. Others in her same group do not. Where would I go to turn this off? She is logged on an AS/400 session and it is still prompting for a...

    CChristo15 pointsBadges:
  • Excel 7

    I have a large spreadsheet with cell that contain  similar older catalog numbers. Want to update to the latest version of catalog number. Can I delete/ remove a character from the following Example:   23LB412  take out the "B" and keep the following: 23L412

    Coppertone5 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