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

    ITKE976,965 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?

    ITKE976,965 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.

    ITKE976,965 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:
  • 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.

    ITKE976,965 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.

    ITKE976,965 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)?

    ITKE976,965 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.

    ITKE976,965 pointsBadges:
  • Error message when executing VBS script that refreshes Excel file

    I recently created this VBS script that refreshes data in my Excel file. But when I tried to execute it, it keeps giving me this error message: object doesn't support this property or method' 'DisplayAlerts'. Anyone seen this before? What's the solution?

    ITKE976,965 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • Pass data from SSRS to Microsoft Excel

    I need to pass along data from SSRS to Microsoft Excel. But I'm not sure of the process. Could I create a link in the SSRS report that opens up into an Excel spreadsheet (with all of the data included in the cells)?

    ITKE976,965 pointsBadges:
  • Remove copy of macro button from Excel 2003 workbook

    How do I remove copy of macro button from Microsoft Excel 2003 workbook?

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

    ITKE976,965 pointsBadges:
  • Remove Microsoft Excel image through Apache POI

    Hello experts, Would I be able to remove an existing image from my Microsoft Excel spreadsheet using the Apache POI? Thanks in advance.

    ITKE976,965 pointsBadges:
  • Move Microsoft Word document headings into Excel spreadsheet

    Sorry for the broad question - I need to get my Microsoft Word document headings into my Excel spreadsheet. What's the best way to do that? Can I use VBA editor? Thanks much.

    ITKE976,965 pointsBadges:
  • Error message when loading data from Excel to Sybase

    Here's my issue - I've been trying to load my data from a Microsoft Excel sheet to a Sybase database table. I keep running into this error message: Error: Incorrect syntax near the keyword 'FROM'. What's that mean and how can I fix it?

    ITKE976,965 pointsBadges:
  • Remove Microsoft Excel groups

    For my Microsoft Excel sheet, I need a way to count all of the groups so I can go ahead and remove them. I don't want to use brute force because of all the errors. Can I do this through VB.NET? Appreciate the help.

    ITKE976,965 pointsBadges:
  • Merge two Microsoft Excel worksheets into one

    On my local machine, I have two Microsoft Excel workbooks and each one contains a worksheet. Now, I need to merge those two sheets into one workbook (as two sheets). Can I do this in Java?

    ITKE976,965 pointsBadges:
  • Freezing Microsoft Excel column

    How to freeze the column for particular dates based on date?

    Lakshmi11235 pointsBadges:
  • Convert Microsoft Excel macros to HTML

    For the most part, I've been using Excel macros to pull data in from our web sources. That's followed by the data being processed. Now, I need to make all of this data usable on my website so other co-workers can use it. Is there a way for me to convert these macros to HTML? Thanks so much.

    ITKE976,965 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