Custom formats
How do I delete a volume of custom formats associated with an Excel 2007 file?

Answer Question   |  April 18, 2013  2:33 PM
Microsoft Excel 2007, Microsoft Excel files

Cell formula
I have a simple 2 column balance spreadsheet. I have my starting balance in column E Cell E4. I want to have a running balance in Column E. Column D has deduction amounts from balance in Column E. I have entered formula =(E4-D5) in cell E5 but this automatically enters the same starting balance from [...]

Answer Question   |  April 1, 2013  3:52 PM
Microsoft Excel 2007, Microsoft Excel formulas

How to change shade color for selected cells
How do I change the shade color for selected cells?

Answer Question   |  March 20, 2013  3:08 PM
Microsoft Excel 2007, microsoft excel functions

Excel formula program
Hi, I’m trying to do a table where I need to calculate how much commission I’m paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but… I don’t want the whole column to change to 10% because I [...]

Answer Question   |  February 25, 2013  1:59 AM
Microsoft Excel 2007, Microsoft Excel formulas

Excel
All of a sudden when I open a number of Excel docs, I don’t see the list on the bottom of the page to click and retrieve. I have to go back up to open and then open them from there.

Answer Question   |  January 31, 2013  8:56 PM
Microsoft Excel, Microsoft Excel 2007

Excel Help!
Hi, I need to create a tool that gives users a question, they select an answer and depending on the answer it will give a question.

Answer Question   |  September 10, 2012  10:42 AM
Microsoft Excel 2007, Microsoft Excel tools

Problem With Microsoft Excel 2007
Unable to copy or paste  and use format painter in excel 2007 cell is not getting highlighted , sometimes it works fine and sometime it doesn’t. sytem configuration is very good using windows 7.

Answer Question   |  June 18, 2012  2:07 AM
Microsoft Excel 2007

Order column in pivote table from vba
I need help to make this, i try with PT4.PivotFields(“Category”).AutoSort xlDescending, “Ventas” but not sorting. Please helpme,          With ActiveSheet.PivotTables(“PivotTable5″).PivotFields(“Ventas”)        .Orientation = xlDataField        .Position = 1        .Function = xlSum        .NumberFormat = “#,##0″        .Caption = “Sum Of Ventas”              End With               ActiveSheet.PivotTables(PivotTable5).PivotField(“Category”) _      .AutoSort xlDescending, “Sum Of Ventas” [...]

Answer Question   |  March 28, 2012  7:15 PM
Microsoft Excel 2007, VBA

problem converting time stored in text datatype to time format in EXCEL
Hi, Anyone has any idea to convert the time stored in text to time format in excel e.g. 0838 0825

Answer Question   |  March 7, 2012  3:51 AM
Microsoft Excel 2007, microsoft excel functions

Replace changes in Excel
I use thousands of references to spreadsheets that don’t exist yet (but will eventually)in conjunction with the IfError function: =IfError(“path and name of future file”,0,”path and name of future file, tab name and cell reference”). I’m copying a workbook with lots of formulas like this and prepping for the our next fiscal year. Excel no [...]

Answer Question   |  February 28, 2012  7:54 PM
Excel workbooks, Excel worksheets, Microsoft Excel 2007

ACT By SAGE Client Notes
I was wondering if anyone had a solution for me to export ACT’s Client notes out to a CSV so I can load them into our new database. I have found the Notes Report but can only export to a txt file with no commas. When opening the txt as a CSV Excel gets everything [...]

Answer Question   |  February 28, 2012  6:12 PM
ACT, Microsoft Excel 2007, Microsoft Windows 7, Sage

How do I associate an employee # to a name in Excel 2007?
I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee’s name. I want to type in the employee’s # in cell A1 and [...]

Answer Question   |  April 24, 2010  2:44 PM
excel, Excel 2007, Excel 2007 workbooks, Excel formulas, Microsoft Excel 2007

How do I overcome the “Could not find installable ISAM. Excel 2007″ Error? Ex
I got the “Could Not find installable ISAM error” while uploading an Excel file in my application.This seems to be happening at the “connection.Open()” code line. – Web Application – .Net 2.0 – Testing using IIS 7.0 on Vista Ultimate – Office 2007 Enterprise Installed on machine. Code works successfully when used in a Windows [...]

Answer Question   |  July 9, 2009  10:06 AM
.NET 2.0, ISAM, Microsfot Office 2007, Microsoft Excel, Microsoft Excel 2007, Microsoft Windows Vista, Web development

WebUtil client_ole2 commands in Oracle Forms 10g
I want to attach a sheet from an excel 2007 datasource to a word 2007 mailmerge using webutil client_ole2 commands in oracle forms 10g

Answer Question   |  June 12, 2009  10:09 AM
Mailmerge, Microsoft Excel 2007, Microsoft Word 2007, Oracle Forms 10g, WebUtil

Excel VBA – Cell value not being displayed
when i display all the values there is a cell that dosnt display it’s result,but when u put the mouse on it in the comment box it appears

Answer Question   |  May 20, 2009  8:43 AM
Excel VBA, Microsoft Excel, Microsoft Excel 2007

Excel 2007 – How to find duplicate data and sort into a row
I have two column. I would like to find the duplicate data and sort the int a row. Eg: Name Name2 Julie Jane Sally John Jack Paul Jane Sally The result: Name Name Julie Sally Sally Jack Jane Jane John Paul Pls help

Answer Question   |  April 21, 2009  6:39 AM
Excel 2007, Microsoft Excel 2007, Microsoft Excel 2007 macros

VLOOKUP in Excel 2007
I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

Answer Question   |  August 12, 2009  10:57 PM
Excel 2007, Excel VLOOKUP function, Microsoft Excel 2007, VLOOKUP

Seperate emails from Excel File
I need to send a 500 e-mails separately to different users depending on their name and e-mail address.

Answer Question   |  April 14, 2009  10:22 AM
Mail merge, Microsoft Excel 2007, Microsoft Excel Mail Merge

Unable to view Excel 2007 workbook
I have open a workbook, but unable to view it. When I attempt to reload, excel ppoup ststes already open. The workbook has macros. The VB editor shows them, therefore the file is open.

Answer Question   |  April 6, 2009  1:48 PM
Excel 2007, Excel 2007 workbooks, Microsoft Excel 2007

Using a drop down window in Excel to look up a List .. The names shown are so small it is difficult to read them
How can I get the Font larger in the drop down window in XL for say cells A1:A200

Answer Question   |  March 20, 2009  10:18 AM
Excel 2007, Microsoft Excel, Microsoft Excel 2007