• Connect Oracle database from Microsoft Excel application

    Is it possible for me to connect to an Oracle database from a Microsoft Excel application without a DNS? I tried to do it already but it keeps giving me an error saying: The driver was not found. What should I do here? What driver am I supposed to use?

    ITKE407,235 pointsBadges:
  • Export SAP reports to Excel

    I have an issue with SAP Reports. I am usually exporting mass data from the system, and my company doesn't allow to have a external system to help for that for security issues. Is there any way I may do to export these reports faster to Excel.

    KarimHosny5 pointsBadges:
  • Excel cannot open the file ‘file.xlsx’ because the file format

    Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

    weinmagaul5 pointsBadges:
  • How to IBM Genius iSeries application connect to Excel VBA

    How to IBM iSeries Access for Windows connect to Excel VBA or can enter data using VBA code?

    Vijay19915 pointsBadges:
  • Best way to run a program in Microsoft Excel or Access

    Good day, I would like to find out what is the best way to run a 'program' in Microsoft Excel or Access (at the moment, I am used to Excel only but I'm willing to learn about Access if that's what it takes) that will allow me to type in one or two letters and it produces a word in the particular...

    asphaltanimal5 pointsBadges:
  • Restrict users from editing in Excel header

    In my Excel worksheet, I currently have a fixed number of columns. All of these columns has a header name. Can I restrict different users from entering anything in those header cells? Thanks so much.

    ITKE407,235 pointsBadges:
  • T-code S_ALR_87013611

    If I look the SAP id of my office mate, the code S_ALR_87013611 was in the excel format. How can I do this in my SAP ID. Thanks!

    eiseljaneenriquez5 pointsBadges:
  • Excel Spreadsheet corrupted (.xls)

    Hello all and thank you in advance for your help. One of my customers has an Excel 2003 document that appears to be corrupt. When I open the excel document I get the following error: "The file you are trying to open, 'database.xls' is in a different format than specified by the file extension....

    Codhard45 pointsBadges:
  • Copy Excel PowerPivot data into a table

    We have a large amount of data in PowerPivot (Microsoft Excel) that's been modified and now I'm trying to put it into my workbook as a regular table. We don't want it as a PivotTable - it's because I have to do some VLOOKUPs for another sheet. How can I do this?

    ITKE407,235 pointsBadges:
  • Convert Microsoft Excel calendar week into date

    I apologize in advance if this doesn't make sense but, in Microsoft Excel, we have a week number and the associated year. In our Excel sheet, can we calculate the date of the Friday of the week in a cell? Is there a formula? Thank you very much.

    ITKE407,235 pointsBadges:
  • Filter Microsoft Excel table

    In Microsoft Excel, I have a large table that I need help filtering with. Furthermore, several of my users asked me to get a total row at the end of it. Here's my concern: Won't the last row be filtered as a normal row? Basically, can I sort out that last row so it's not filtered? Thanks!

    ITKE407,235 pointsBadges:
  • Store MySQL query in Microsoft Excel

    I have a MySQL query and I need to store it in Excel. Here's the query I have: SELECT * FROM document WHERE documentid IN (SELECT * FROM TaskResult WHERE taskResult = 2429) How can I go about doing this? Thank you very much.

    ITKE407,235 pointsBadges:
  • Excel crashing when emailing ranges

    Hello, I have created a worksheet for my company that covers all areas of our business. I have inserted ActiveX buttons allowing me to email only certain cell ranges directly to the body of the receiving email address. I have also created a terms and conditions box as well as contact information,...

    Peanut425 pointsBadges:
  • How do I extract the top 5 from an Excel column if there are duplicates?

    I have a stats sheet and need to pull the top 5 players' names and their stat out.  The issue is that I get the first player's name (that has the stat) for each entry that has the same stat total. In the example below I get Rae for both of the "5" stats...

    mtnmaiden5 pointsBadges:
  • Convert PDF to Excel

    How to convert PDF to Excel?

    LDS5 pointsBadges:
  • Editing excel file after converting it from pdf file?

    At first I convert the pdf file to text file using acrobat reader. after that i open the file through excel.  But i didnot get proper output of my file as the pdf format. the pdf format contains picture & tables also.

    Papuli5 pointsBadges:
  • PDF format file change to Excel

    My friend got one PDF file and contain some table based data. How can we convert that file to Excel format?

    Tonycheng5 pointsBadges:
  • Critical Path

    I created a project plan and everything looks normal but when I want to view for a critical path (using Gant Wizard Chart), I don't see any critical paths. I am wondering what went wrong

    MSProject5 pointsBadges:
  • Finding the list of processes executed on a queue

    I want to generate an Excel sheet of processes executed on particular queues. Please assist.

    makxxd3564565 pointsBadges:
  • ASCII code VS. ASCII text file

    If I convert an excel spreadsheet containing hundreds of sheets in the workbook to text file format is that the same as ASCII code? Also, is there a way to convert the whole workbook or do I have to do each page one at a time?

    zoombug5 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