Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of this file, and in the new copy, change the numeric value of 20 cells. No new columns or rows are added, there are no graphics/charts/etc. There is only one sheet. 10...
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 created some Excel spreadsheets that use an external connection and MS query to download data into the SS. (No VBA involved). I would like to hide the query and connection information from users, or make it inaccessible. I want to avoid users making changes to the connection and/or query...
I need to find the interest rate on a loan using vlookup in excel, selling price $250,000 on a 20 year loan.
I am looking to create conditional formatting based on the top n values in a range. Values in c1 to l1 (10 values). I want the number of values to change so want to base it on the value in cell b1 rather than simply using the top 6 conditional formatting so that I do not need to keep changing the...
So I am given times of the day and I need to match the shift with the time so I was wondering if there was a macro that would make this easy. For example, between 07:00 and 15:00 is shift 1 and 15:00 to 23:00 is shift two and the other period is shift 3. I'm sure that there is a loop for this but...
I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?
I have important MS Excel file data and unfortunately got corrupt due to virus attacks, so my crucial Excel sheet got lost, how to repair corrupt MS Excel 2003 (XLS) File? If have any solution please assist me.
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!