• Cannot open Microsoft Excel document

    I work in the IT department for my company and one of our employees came in with an interesting issue with Microsoft Excel. When he tries to open a document, he keeps getting this error message: An error has occurred in sending the command to the application. I already tried a bunch of things but...

    ITKE1,012,075 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:
  • Connect Excel to Rumba 8.2.0

    My company is using AS/400 Micro Focus Rumba 8.2.0 SP0. Every time we want to run a report we must spool file the query and send it to our email, then we import it into excel. but I wanted to know if we can directly connect Excel to Rumba.

    hoomansd5 pointsBadges:
  • Microsoft Excel keeps asking to disable macros

    Whenever I try to open up Microsoft Excel, it keeps asking me this: This workbook contains macros. Do you want to disable macros before opening the file? Is there a way to have Excel stop asking me that?

    ITKE1,012,075 pointsBadges:
  • how to save crystal report in excel format ?

    hi i wanna to save crystal reports as excel form so can anyone help me

    Romanticknight5 pointsBadges:
  • Why does right arrow key keep scrolling in Microsoft Excel 2016?

    I've noticed that in Microsoft Excel 2016 that my right arrow key keeps scrolling to the right instead of tabbing over to the right. I honestly have no idea why this is happening. I need to correct this ASAP for my reports. Can anyone help?

    ITKE1,012,075 pointsBadges:
  • How to save a Microsoft Excel file to CSV

    I've been having a ton of issues saving my Microsoft Excel file to CSV. When I'm saving it, many of the characters change from dash to a question mark. Why would this be happening? Do I have to do some encoding changes? Thanks so much.

    ITKE1,012,075 pointsBadges:
  • Crystal Reports export to Microsoft Excel

    When I export my Crystal report to "Excel 97-200 - Data only", some row fields in the spreadsheet contain different data than the report shows. The wrong exported data is from other records in the group. When exported as a PDF the data is as it appears in the report. Why is the data incorrect in...

    RobinRay5 pointsBadges:
  • Sort Microsoft Excel sheets alphabetically

    Hey everyone, I need to sort several Microsoft Excel sheets into alphabetical order. How can I do that? I'm not too entirely sure of the 'sorting' part. Thanks!

    ITKE1,012,075 pointsBadges:
  • ORA 12154 error when fetching data from Oracle

    My boss gave me a Microsoft Excel file (which my predecessor used) and it uses an external data connection to fetch our data from Oracle. I've been trying to migrate this file to my PC but I keep getting this error message: ORA 12154 TNS could not resolve the connect identifier specified. What's...

    ITKE1,012,075 pointsBadges:
  • How to lock Microsoft Excel cells

    Hi, Could anyone tell me if there's a way I can lock Microsoft Excel cells (with different equations) so Excel doesn't autoedit them. I tried Freeze but that didn't work. Thanks.

    ITKE1,012,075 pointsBadges:
  • Excel 2013 Linked formulas

    Receiving problem "sending the command to the document" when opening a linked file. Once opened it was under a different name XI0000026 Compatibility Mode Read Only. The data did update once I hit “enable content.”

    Crisheff5 pointsBadges:
  • Format older Microsoft Excel files into newer version

    I have a bunch of older Microsoft Excel files (some even Excel 97) that I need format into the new version. Is that remotely possible? I tried Apache POI but that didn't work. Thanks!

    ITKE1,012,075 pointsBadges:
  • Create heat map on Microsoft Excel 2013

    For a project at my job, I need to create a heat map in Microsoft Excel 2013. I'm trying to do it using Power Map but I'm not seeing it on the Insert tab. The add-in is available and I checked it off. What's the issue? How can I get it to appear?

    ITKE1,012,075 pointsBadges:
  • Create Microsoft Excel files in ASP.NET

    Hello experts, I have a more broad programming question for everyone. For ASP.NET, is there some package/interface that would allow me to create Microsoft Excel files? I haven't been able to find anything.

    ITKE1,012,075 pointsBadges:
  • Hide and unhide Microsoft Excel sheets in Python

    I need to hide and unhide several of my Microsoft Excel worksheets in Python. I'm currently using openpyxl but not too sure of the process. How can I do it?

    ITKE1,012,075 pointsBadges:
  • Add number to range of Microsoft Excel cells

    In my Microsoft Excel spreadsheet, would I be able to add a new number to my dynamic range of cells? Here's an example: I have a range of cells from B1: B20. How can I add B21, B22, etc.

    ITKE1,012,075 pointsBadges:
  • Resize Microsoft Excel table to fit screen

    In my Microsoft Excel program, I have a table that queries a database on a daily basis. So the amount of rows in the table moves from time to time. Would I be able to resize my table so when the rows increase, the table still fits the screen? Thank you.

    ITKE1,012,075 pointsBadges:
  • Copying data from Microsoft Excel to Notepad

    For my company, I do a ton of copying data from Microsoft Excel to Notepad. But every single time, I have use the SendKeys Excel VBA command. Is there a better (or easier way to do this)?

    ITKE1,012,075 pointsBadges:
  • Split Microsoft Excel data using SQL query

    Hello everyone, Most of the time, I've been using a SQL query in Microsoft Excel to display all of my data. But now, there's too much data (over 200 rows) and I need to split it up. So 100 side-by-side. How should I do this? I tried cut and paste but that didn't work. Thank you.

    ITKE1,012,075 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