• How do you calculate formulas in Excel 2007?

    I am new to Excel and have a project to do tomorrow at my new position. We have contracts that start on a certain date in 2010 and will bill for various time periods. For example, we received a  240,000contract and will bill for the remainder of 2010 at $10,000 per month. The total for 2010 will...

    Cathraff5 pointsBadges:
  • 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.

    DaveInwood30 pointsBadges:
  • Are user subs and functions in the microsoft office object model hierarchy?

    I'm an experienced Excel VBA programmer, who is trying to write a macro in Excel that uses functions and subs in Outlook.  I've done some searching and found that the standard answer looks something like: <code>     objApp = CreateObject("Outlook.Application")     call...

    Jwolter5 pointsBadges:
  • 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.

    raj2275 pointsBadges:
  • Excel 2007 – allocating non-repeatable values in a set

    I am creating a questionnaire. There is a set of 4 words and users are asked to rate each word with a value from 1 to 4. The user can not repeat any of the values between the 4 words in one set. There are many sets of 4 words and as a result, this process has to be repeated many times. I am...

    Ubilkhu5 pointsBadges:
  • Is there a standard formula for counting highlighted cells in Excel 2007?

    Is there a formula for when you highlight some data cells, for use of simply counting rows, that Excel will give you the count of those cells as the answer on another sheet in the workbook- just by highlighting? But this is based on highlighting random cells in a column every day, never the same...

    Buddyboy12310 pointsBadges:
  • Excel Error message

    I am unable to oen excel files in documents because the message 'there was an problem sending the command to the program' appears. A blank eecel page appears and I am able to open files via the recent documents link. Is there any explanation and solution to the problem

    Knuprotcod5 pointsBadges:
  • 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       ...

    Emoraleshn5 pointsBadges:
  • 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

    Leyenda15 pointsBadges:
  • Issues with Microsoft Office 2007

    OS: Vista Home Premium Here's a list of the issues I'm experiencing - very strange behavior. 1. When I try to open a .doc or .docx file from Windows explorer, word opens up, but doesn't display the document - just the grey default screen. When I open up word, and then open a file up from there, it...

    Mouse19995 pointsBadges:
  • Sending HTML file with record length of 5000 char

    I need to send an email with an HTML file attached from the mainframe via SMTP. Even with adding a DCP (LRECL) parameter, the spreadsheet is truncated to the 1st 1024 characters. How do I fix?

    WLR15 pointsBadges:
  • export to ms excel

    I get extra columns when exporting to MS excel. It appears there is an extra column every time there is a sub report

    Mstang19875 pointsBadges:
  • 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...

    Bossann5 pointsBadges:
  • Excel 2007 saves the file when I close it without prompting me even though no changes were done

    I'm using Excel 2007 and often when I open an excel file and then close it (without touching anything or changing anything) the "Date Modified" is changed to the current date. Meaning the file was saved again without prompting me if I would like to save it and changes its date. Is this situation...

    Am805 pointsBadges:
  • 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 completely messed up. The txt file...

    RamseyB2,115 pointsBadges:
  • Vlookup repeated dates

    I have a spreadsheet (A) with various data, where one column contains variuos dates, and one column with values. I want to be able to distinguish all values for each year, so I have another spreadsheet (B) with a long list of all dates for 2010, 2011 and 2012.  I use vlookup...

    Msva5 pointsBadges:
  • how to create autonumber

    while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls

    Army125 pointsBadges:
  • Adding “days” to a cell in Excel 2007

    I have a list of # of days' inventory for a product and wish to add "days" to each cell. For example, "29" would appear as "29 days", with the numerical value unchanged, so my formulas still work. How do I do this?

    Chirofriend5 pointsBadges:
  • use Data connection wizard / Microsoft query to get data from as400 to excel 2007

    Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don't know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database,...

    Clarksonneo15 pointsBadges:
  • Keep Text to Column format in Excel 2007

    We're wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format...

    Littlejuanito7420 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following