• How to collapse data in a Pivot Table in Excel 2007?

    I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collapse all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to collapse.

    Babyphat5 pointsBadges:
  • How do I save as XLAM Excel add-in

    I have some code that I want to use in Excel as an add-in. I have Excel 2007 and VB Express 2008 installed on XP Pro SP3. I see everyone saying to "save as XLAM Excel add-in" on forums and sties, but can't find that option anywhere on my apps. What am I missing?

    swinehart68031,050 pointsBadges:
  • 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:
  • 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:
  • 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:
  • What are Excel internal limit for size and formula complexities/

    MS Excel 2003 and 2007 crash when handling oversized spreadsheets. The RAM memory is 4 gig and has plenty of memory. The machine is running Windows XP Pro. The spreadsheets have many calculations and formulas and have been set to Manual. Also have tried the 'control-end' on each sheet to no avail....

    Gaiusd5 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:
  • 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:
  • 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:
  • Excel 2007 ‘Edit Links’ Command deleting information

    I received a file from our corporate office. Some of the formulas in the workbook were referencing a location on a persons C:documents and settingsthatpersonmy documents. I wanted to change the reference to the existing file instead of the past months file it was looking at. I went into DataEdit...

    Hporiginal15 pointsBadges:
  • In Access 2007 for query exports to Excel 2007 – How do you turn off Automatic backups

    How can Access 2007 be set so that when it exports queries to Excel 2007, backups are NOT created in Excel each time the Excel file is saved?  How can Access 2007 be set so as not to cause EXCEL 2007 to backup exported query files?

    2010475 pointsBadges:
  • Create a macro in Excel 2007 to disable save

    I need to create a macro in Excel 2007 to disable save

    Basilmartin5 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