• Imbed and Link External Excel Spreadsheet into Visio

    Looking to utilize an external spreadsheet which maintains various information pertaining to our move from one data center to another. Items included are ip address, rack, U, hostname. The question is I want to utilize this spreadsheet as my source. Then within my Visio, I have tabs for each Rack....

    Aguacer08,135 pointsBadges:
  • 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?

    Newkid4735 pointsBadges:
  • Excel 2007 – gauge, speedometer, or dial charts

    Hi, Does anyone have any idea were I could find some some sample templates on these 3 for: Excel 2007 - gauge, speedometer, or dial charts. Thanks Jared~

    Jreifenstein001185 pointsBadges:
  • Combo box in Microsoft Excel

    How do I link numeric values to word choices in my combo box? I have tried If Then's for if you pick a certain choice it = a certain number, but I'm stuck! Thanks.

    Toriel5 pointsBadges:
  • SAP export to Excel 2007

    When exporting a spreadsheet to Excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I've tried to format the cell but this does nothing. Also I've verified switching the regional settings but no luck there neither. Help will be truly appreciated, Max.

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

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.

Following