• Export to Excel

    Why does Crystal add blank rows and columns when I export to Excel?  How can I export without blank rows and columns?

    RicksterS5 pointsBadges:
  • Transaction web page using MS Excel

    How to develop transaction web page using MS Excel as database?

    ramki19805 pointsBadges:
  • Microsoft Word or Excel

    Why when I double click the created small Word or Eccel files, the program won't open the document anymore?  The program only opens the first page of the program as we click the Word or Excel icons.  I now always need to go to Word or Excel main program or icon to select the created document...

    paul180815 pointsBadges:
  • Do you have a favorite construction estimating software tool?

    What is your favorite construction estimating software tool? Are you using Microsoft Excel? What about Sage? HeavyBid? HardDollar? Something else entirely? What makes the software so appealing to you -- was there one feature that made you shout, "I need that now!" or was it the whole package that...

    Beastwood1,105 pointsBadges:
  • Filename error in VBA

    I created a macro to run with my daily reports in Excel. The only issue is the names of the report change every day respectively as Mat1 mm-dd-yy. I have tried to maneuver with the code but it always leads to a dead end. How can I change the code to be able to run with any date? Mat1Macro Macro ' '...

    ambershantae5 pointsBadges:
  • 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:
  • 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 Khanduja8,975 pointsBadges:
  • Excel

    How do I find the sum in an Excel spreadsheet?

    Keteleyne1215 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:

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