• Privacy warning in Microsoft Excel 2007

    When I'm tried to save a spreadsheet in Microsoft Excel 2007, I often get this "privacy warning" message. This happens with both macro and on-macro spreadsheets. Is there any way to get rid of this message?

    ITKE350,300 pointsBadges:
  • 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:
  • 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:

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