So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.
I have a large CDB file of car part numbers. I need to open it and convert it to Excel.
How can I link data in sequential Excel spreadsheets without having to open all of them?
Is there a format I can buy or can I convert an Excel spreadsheet into a flat text file?
Hello, The aim is to click a slice on a pie pivot chart, that will show another pie pivot chart, NOT data. Is this possible with Excel, again I want to click a slice on a pie pivot chart, that then leads to another pie pivot chart. Preferably go 3 or 4 levels down. Thank you.
I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks...
Is it possible for me to connect to an Oracle database from a Microsoft Excel application without a DNS? I tried to do it already but it keeps giving me an error saying: The driver was not found. What should I do here? What driver am I supposed to use?
I have an issue with SAP Reports. I am usually exporting mass data from the system, and my company doesn't allow to have a external system to help for that for security issues. Is there any way I may do to export these reports faster to Excel.
Every now and then, when I try opening an Excel file, I get a message saying that "Excel cannot open the file 'file.xlsx' because the file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
How to IBM iSeries Access for Windows connect to Excel VBA or can enter data using VBA code?
Good day, I would like to find out what is the best way to run a 'program' in Microsoft Excel or Access (at the moment, I am used to Excel only but I'm willing to learn about Access if that's what it takes) that will allow me to type in one or two letters and it produces a word in the particular...
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.
If I look the SAP id of my office mate, the code S_ALR_87013611 was in the excel format. How can I do this in my SAP ID. Thanks!
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....
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?
A Microsoft word file has suddenly become an "07" one and I cannot open it or do anything else with it. How do I change it back to Microsoft, please? I have been using Libre Office software (if that's the right word!). Thank you. Regards, Bill Swanson.
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.
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!
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.
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,...