• Comparing 2 Large Excel Files

    I have 2 large Excel files, one containing yesterday's data, and another containing yesterday's data + today's updates/changes. For registration purposes, I need to find all the differences (ie new rows/entries, a value changed within the row in the new file vs the old file, etc). These excel files...

    Drawde5 pointsBadges:
  • How to repair corrupted files

    My MS Word, Excel and PDF files have been corrupted and these files are showing there file extension as "qbnzgel". How to open this type of files?

    tanveerhamza5 pointsBadges:
  • Cannot open Excel file: File format is not valid

    Excel cannot open this file because file format or file extension is not valid

    rajendermadan5 pointsBadges:
  • How to Migrate from Outlook Express to Windows Live Mail on new Computer

    I have been using Outlook Express on Windows XP operating system. Recently I have upgraded to Windows 10. In this operating system I am using Windows 10 Mail. Which is quite impressive. But Outlook Express contains some crucial email from clients. So, I want to access Outlook Express DBX Files in...

    WarriorBhagat355 pointsBadges:
  • Convert Excel to JSON using VBA

    I need to write an Excel macro which will convert the excel workbook into a JSON file. The excel will have multiple sheets, each sheet will have a tabular form of data (in rows and columns). One of the column will have hyperlinked data and the macro should extract and explicitly list the hyperlink...

    6r2,220 pointsBadges:
  • Exporting to Excel – Sort doesn’t work due to merged cells

    How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

    Gma885 pointsBadges:
  • Export SSRS to Microsoft Excel without any headers

    I have a SSRS report that I need to export to Microsoft Excel. But here's the kicker - my header that's on the first page of the report has to be removed from Excel. How can I do that?

    ITKE1,100,915 pointsBadges:
  • How to create exe file for Excel macro in VB without DoneEx XCell Compiler.

    With DoneEx XCell Compiler. It expires with 3 days (trial version).

    SumanLata10 pointsBadges:
  • Upload Excel file into AS/400

    Can an excel file be uploaded into AS/400?

    Tammyc15695 pointsBadges:
  • Microsoft Excel: Create multiple charts for same data set

    In Microsoft Excel, I have a data set of about 5000 rows and columns. I need to create multiple charts in different sheets for every 100 rows. What's the best way to do that? Thank you.

    ITKE1,100,915 pointsBadges:
  • Cannot import CSV file to Excel: Cannot download the information you requested

    I have this CSV file that I can't import into Microsoft Excel. This is driving me insane! I keep getting this message: Unable to open XXX. Cannot download the information you requested. It's showing up in the preview screen. What can I do? I'm on Excel 2016. Thanks.

    ITKE1,100,915 pointsBadges:
  • Microsoft Excel is showing strange black lines through spreadsheet

    So whenever I'm opening up a new Microsoft Excel file, it keeps showing these weird black stripes and boxes. Basically lines through all of the cells. Is there a setting on that I need to turn off?

    ITKE1,100,915 pointsBadges:
  • Combine two Microsoft Excel formulas into one cell

    Hello - this is a curiosity question more than anything else. In Microsoft Excel, is there an easy way to combine two formulas (from two cells) into one cell? I just want one formula in the one cell. As of right now, it's two formulas in two cells. Thank you!

    ITKE1,100,915 pointsBadges:
  • Moving formulas over to new column after copying Microsoft Excel spreadsheet

    Hi, Here's what I want to do. I would like to copy an Excel worksheet to a new sheet but there's the catch: I need to move all of the formulas into a new column. I just want to move them over one column. How can I arrange this? Or would I just have to do this manually?

    ITKE1,100,915 pointsBadges:
  • Make changes to Microsoft Excel Gantt chart

    My friend sent me a Microsoft Excel template for a Gantt chart (I need to use it at my office). But I would like to make some changes to the chart itself (particularly the colors and different formulas). How can I do that?

    ITKE1,100,915 pointsBadges:
  • Transfer data from one Microsoft Excel cell to other cells

    So I think the answer to my question is a macro but I need to make sure. In Microsoft Excel, I need to transfer data from one to various other cells in my worksheet. How can that be done? Would a macro work here?

    ITKE1,100,915 pointsBadges:
  • Open Zax files in Excel

    Can l open .zax files in excel?

    EdwardCormani10 pointsBadges:
  • Microsoft Excel spreadsheet keeps getting corrupted

    We have this pretty old Microsoft Excel spreadsheet that gets saved several times a day. But we've begun to notice that it gets corrupted about once a week. It has a couple of plugins and is using the latest version of Office/Excel. Why does it keep getting corrupted? Any suggestions?

    ITKE1,100,915 pointsBadges:
  • Change English numbers to Arabic numbers

    How I can change English numbers to Arabic numbers?

    Mark475 pointsBadges:
  • Disable Microsoft Excel sheet bounce

    Hi experts, I'm not sure anyone can help but here goes: At the top of an Excel spreadsheet, does anyone know how to disable the sheet bounce (or touch scroll bounce)? Hopefully I said that correctly. The bouncing values are set at zero but it's not working. Any ideas? I'm on Windows 10

    ITKE1,100,915 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.

Thanks! We'll email you when relevant content is added and updated.

Following