• 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:
  • Change a field in a file

    I created a file using qry400, to hold the position of a field I used spaces '    ', now when I try to download to an Excel spreadsheet the info in that field comes out looking like HEX instead of what is in the field. Is there anyway to correct this? *** note - I must fix the file, I can not...

    hydr15 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:
  • 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:
  • Scrolling

    In working with MS Excel 2003, there are darker scroll lines vertically & horizontally on the worksheet. When I try to scroll the page down below the line, only those cells scroll, not the whole sheet. How do I fix this?

    nccoolmom10 pointsBadges:
  • Opening Excel

    We use a shared workbook. As I understand how Excel is supposed to open, it should be at the same place where I last saved it. Instead, it opens at that location and then jumps to a weird place on another sheet. I cannot figure out why or how to make it go back to opening normally.

    tlsanders11,340 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:
  • 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 Khanduja10,425 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:

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.