• 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.

    ITKE406,440 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.

    ITKE406,440 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!

    ITKE406,440 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.

    ITKE406,440 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:
  • Analyzing an Excel spreadsheet divided by categories and subtotal

    Column B has various vendors, column F Has Totals, Row 5 has a category subtotal which totals all categories in column 250,and row 7 starts a new category. I would like to create a total of each vendor in a table, what is the best way?

    Kerrie12345 pointsBadges:
  • Reading Excel with RPG HSSF

    I set up a program to read Excel on my AS/400 using the klement examples then move to user AS/400 and cannot get it to read the Excel. Program compiles fine.

    mr400man5 pointsBadges:
  • Row of data not transferring to Microsoft Word when using mail merge

    I'm using mail merged to transfer data from Excel to Word for my job. I just had to write a bunch of code to update to Word 2013 for it to work. However, when I try to transfer everything, it works perfectly except there is a whole row of data that does not transfer to the Word document. Everything...

    SARAHCYOUNG205 pointsBadges:
  • Export / import data from Excel to SQL database

    Hi, I want to do one program in which I have one Excel sheet that some data can be stored. I want to import that data in VB.NET application and store it in a SQL database and do same thing vice versa. Which means I can fetch data from SQL database through VB.NET and store that data in Excel. Please...

    qwertyudicdi10 pointsBadges:
  • Microsoft Excel: How to find top 10 figures based on a condition like country wise

    I do have sales figures country wide and i would like to make a separate table for each country and populate top 10 sales figures in XLS. Thanks in advance.

    rangagom15 pointsBadges:
  • Load Excel with Japanese characters to iSeries DB2 file

    How do I load an Excel spreadsheet containing Japanese characters to an IBM iSeries DB2 file?

    tonycurtis135 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:
  • MS Office 2007 Excel files not opening

    I have MS Office 2007, Windows 7. When I double click on an XLS file, Excel opens up but it is just a empty Excel program. It is similar to opening up Excel and then just closing the book1 that opens up automatically. Just a grey background. Also I can't open up XLS files by doing File > Open or...

    CharlessReynoldss5 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