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!
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...
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.
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.”
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!
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?
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.
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?
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...
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.
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.
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)?
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.
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?
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...
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)?
Somehow, in Excel 2003 I have 4 copies of the same macro on the toolbar (not sure how that happened). However, when I click on Tools>Macro>Macros, there are no macros shown, and all options are grayed out except Cancel. When I go to Tools>Add-ins, one copy of the macro is shown, and it...
How do I remove copy of macro button from Microsoft Excel 2003 workbook?
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.
Hello experts, Would I be able to remove an existing image from my Microsoft Excel spreadsheet using the Apache POI? Thanks in advance.