• Unable to run macro in Microsoft Excel 2007

    I'm unable to run any macros stored in this workbook but macros stored in the personal file will run. What should I do?

    Rich6245 pointsBadges:
  • Excel Macro Help – .ThemeColor = xlThemeColorDark1

    The spreadsheet I'm working on pulls data from an oracle database and automatically populates cells for which there is no data with "999999." I am attempting to use an excel macro to essentially gray-out all cells that contain this value with the intention of saving users the time it takes to apply...

    Jwahl5 pointsBadges:
  • How to connect to quick 3270 secure screen through VBA macro?

    Hi, I use the following code to connect to quick 3270 macro and it also connect to the screen. But when I run the macro for the first time it works, but does not work when I run the same macro for second time. If I restart the mainframe then the macro runs. Below is the code. Sub getdata() Set...

    Anirudha0075 pointsBadges:
  • Disable saving in Excel 2007

    Hi, I need to get rid of the save option. I only want the sheet able save when the document is closed and it asks if you want to save. I do not want the document to be saved any other time. Here is my document (Office 2007 Only). http://www.savefile.com/files/1848919 It has been made to book out...

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

    Weazel5830 pointsBadges:
  • Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph?

    Excel 2007 - How do I ignore zero's and #DIV/0! for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% #DIV/0! 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2....

    Jreifenstein001185 pointsBadges:
  • How to I create a Chart in Excel 2007 from Non Numerical Data?

    We have several projects going at work and my boss is tired of sorting through Spreadsheets and told me to graph everything. I need to figure out how to make a chart register how many of word/phrase A, B, C etc. there are in a column and stick that in a graph. If anyone could help I would really...

    Kuroia5 pointsBadges:
  • How do I run Excel Reports?

    Is is possible to run reports similar to how you run reports in Access in Excel 2007? If so, how?

    Lysprice5 pointsBadges:
  • 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:
  • Excel 2007-There was a problem sending the command to the program.

    No existing Excel document will open. I can create a new document & save it but it will not open. Excel diagnostics doesn't detect any problems. Un-installed Excel and the existing documents opened. Installed SP3 & updates & now existing documents won't open.

    TLeemoneyman10 pointsBadges:
  • Exchange 2007

    How can I take an e-mail with 450 zipcodes and put it an Excel format?

    Pduvall25 pointsBadges:
  • Excel cleanup

    I have multiple values that bleed over into multiple cells. How can I clean it up to be one value, once cell?

    Pduvall25 pointsBadges:
  • Pivot table changing into values on save

    I have created a pivot table in which one field is calculated field. I saved and closed this pivot table. Next time when I open it is changing into normal Excel table with values. But I want this to open as pivot as is. How can I rectify this problem? Please help someone. Application using: Excel...

    individually5 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:
  • Custom formats

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

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

    Schwenky5 pointsBadges:
  • How to change shade color for selected cells

    How do I change the shade color for selected cells?

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

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

    Mrboop10 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:

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.

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