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

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

    ITKE406,465 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,465 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,465 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,465 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:

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