**[Solved] Excell .xls File Growing Fast** *Summary*: 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 ...

**[Solved] The file format/file extension is not valid.** *Summary*: Hello. I am using MS Office 2007 on my pc and I have several excel files which I always use at work. Naturally I used these files daily until recentl...

**DBF file corrupted when saving through excel 2007** *Summary*: Hi all, I have a dbf file that I open with excel 2007. The content of the file shows correctly. The content of the file gets corrupted if I save (in D...

**[Solved] How do I make an Excel 2007 worksheet work in Excel 2013?** *Summary*: I have a spreadsheet that I put on a group drive for another region of the state to use. This spreadsheet was done in Excel 2007. It was working fin...

**[Solved] How to use if for two colum ranges** *Summary*: if c4:c48 = barb and if e4:e48 = y then count all the y's in a sepreate cell. So I'm trying to count all they y's for a person... need help! ...

**[Solved] Color changes to a cell using IF** *Summary*: Using a spreadsheet for scheduling, and if an employee is Part Time, should have 32 or fewer hours. Full time should be 40 hours. I want to color co...

**[Solved] freeze four panes in a single spreadsheet in excel 2007** *Summary*: I have a spreadsheet where top 5 rows form the header and are already fixed. The first column i.e A is already fixed. Now I want the row 371 to be fix...

**[Solved] Excel 2007: Multiple Formulas In One Cell** *Summary*: I want to apply multiple formulas to single cell i.e in first case it is =SUM(D6+G6+J6) and then I want to have sum of D6 to D370.How should I do it? ...

**[Solved] Recording macro in excel 2007** *Summary*: I am having a problem I cannot resolve when recording macro in Excel 2007. I am trying to record macro in a file which has the following: 1. Sheet one...

**Comparing Names to string of text** *Summary*: I have a list of names i.e. John Smith Jones and have copied in a conversation from face book with names and comments. I am looking for a solution in ...

**[Solved] excel 2007 how to return 1 or 0 with IF** *Summary*: How do you give a "Yes" or "No" value as a 1 (0ne) for "Yes" or a 0 (Zero) for "No" in Excel 2007 to do an if statement. =IF(P3=1,N3,0) ...

**[Solved] Tab names with/without spaces in formulas???!!!** *Summary*: I don't remember in Excel 2007 a tab name with a space being treated differently in a formula than a tab name without a space? I thought I did it all...

**[Solved] Cells not updating automatically** *Summary*: I am using excel 2007, i have added my formulas into the cell I need but it doesn't automatically update the answer when I enter the data into the cel...

**Drop Down lists do not appear for me - but work ok for other** *Summary*: I have excel 2007 - the spreadsheet was created in 2010 - with drop down lists. others in my co have 2007 - and they can see the drop down lists. i...

**name reverts back to a previous one in Excel 2007** *Summary*: At the very top line on the worksheet, it reverts back to August although I have renamed it to September ...

**[Solved] Excel 2007 keeps configuring** *Summary*: I have installed office 2007 on my XP sp3 machine . . All applications work well except Excel . Every time I open it a screen opens up saying Excel...

**[Solved] Using summation in Excel 2007** *Summary*: Why does Apr-00 appear when adding cells that have only numbers in them. All the other rows have done it correctly. ...

**[Solved] Sort algorithm in Excel** *Summary*: I'm trying to construct some formulas in Excel 2007 to sort some data and I'm just having trouble implementing a suitable sorting algorithm that gives...

**[Solved] Functions in Excel 2007** *Summary*: =IF(F5<=G5,1) this works but I want to beable to add to this (F5<=H5,2), (F5<=I5,3),(J5<=G5,4), (F5<=K5,5), (F5>=K5,6) How can I look a...

**[Solved] Find multiple words/values in Excel and add date** *Summary*: Hi I am currently using the code below to find multiple values and the copy/paste into another sheet. What I would like to know is if it is possible ...

**[Solved] Identify different numbers in a cell w/text and numbers** *Summary*: Delete the numbers following the pound symbol from text string. How do you tell Excel 2007 that you want to identify any set of numbers following the...

**[Solved] Countup timer for Excel** *Summary*: I need a very simple timer for Excel 2007 with START and STOP buttons, showing the mm:ss spent on a certain task (serving customer). Can it be done, p...

**Removing a worksheet from a linked formula (Excel 2007)** *Summary*: I have 10 worksheets that are my base and an 11th that is a roll-up with links/formulas based upon previous 10. I was informed to remove one of the s...

**[Solved] Insert rows between different screenames in a chat history?** *Summary*: Here is how my data appears after I paste it from Excel into Microsoft word (it is from a chat history): 10/26/2009 TV Si, te equivoque muuuuucho! 10...

**[Solved] Test Wifi signal Strength using Excel VBA** *Summary*: Hi there, I've built an app in VBA (Excel 2007) which is a portable application. It can work in a number of locations and will occasionally need to tr...

**[Solved] How do you repeat the same formula in different cells?** *Summary*: OK SO NOW THAT I'M ABLE TO GET MY FORMULAS TO WORK HOW CAN I GET IT TO REPEAT. FOR EXAMPLE IF I WANT THE SAME ANSWER IN FORMULA IN K-2 TO WORK FOR K'S...

**Importing/coping data from one spreadsheet into another but** *Summary*: I am trying to import rows with certain value into a new spreadsheet. Specifically, I have a report with mutiple states testing results on it. I need ...

**[Solved] I'd like to close a batch file from VBA code in excel 2007** *Summary*: I've written a simple batch file which connects my pc to a server, configures and copies files to the local machine and then launches an excel 2007 ap...

**Move items in a column to a new column (not manually)** *Summary*: I have exported data into Excel that shows up in one column - student name and ID# with the courses they signed up for listed underneath. I need a col...

**Automatically inserting a blank row based on selection** *Summary*: For Excel 2007 I need a macro to automatically add a blank row below the active row when a user selects "Subpart H Pre-clearance" from the drop down m...