Excel 2007 Related Problems & Solutions

108 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 108
[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...

1234


Ask Question