Productivity Software Tag Directory

Browse Alphabetically:

Featured Productivity Software Questions

  • Wildcard Characters in Microsoft Excel

    I have a formula to search for a code and return results. The problem is that within the code there are wildcard characters. How do I make wildcard characters searchable text?

    Shultzie5 pointsBadges:
  • MS Office Excel 2007 cannot be open by MS Office Excel 2003 (even after installing compatibility pack)

    Cannot open the EXCEL file using MS Office EXCEL 2003 (after installing the Compatibility pack) that was saved by MS Office EXCEL 2007. The error message: This file is not in a recognizable format. If you know the file is from another program which is incompatible with Microsoft Office EXCEL, click...

    Phlim35 pointsBadges:
  • What formula is needed for this below in Excel?

    What Excel Formula's could I use? First # is starts with 1  back slash 2400. 2400 stays the same only first # changes. Example below: [table style="border-collapse: collapse; width: 65pt;" border="0" cellpadding="0" cellspacing="0" width="86"> [col style="width: 65pt;" width="86">[/cOLIST]...

    Jreifenstein001185 pointsBadges:
  • Excel 2003 docs now won’t open in Excel 2007

    I created som docs using Excel 2003. New computer has Excel 2007 installed and now when I open the docs they are unreadable. Any help would be appreciated.

    Anniedun5 pointsBadges:
  • Password protecting Excel 2010 files

    Can we password protect an Excel 2003 document and what happens if the password is lost? Can it be recovered? If so does this ruin the password protection and illusion of security it provides?

    Karl Gechlik9,860 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:
  • Microsoft Excel Graphing

    I need a line that is able to move. I want to grab it with my cursor and move it up and down on my bar graph. The bar graph is showing the zero to the max percentage of the percentage of income brackets for each year from 1913 to 2013. So there are 100 vertical columns (bars). The series of the...

    ITKE352,485 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 pointsBadges:
  • Excel and Access integration and auto-population

    Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to...

    Sm6hans25 pointsBadges:
  • Excel 2007 Macros problem

    Hello, I am using Office 2007. The Macros are disabled when we open password Protected Workbook. What should we do?

    Mobilink115 pointsBadges:
  • Date format in Microsoft Excel 2002

    In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as ... Exl.Range("A1").NumberFormat =...

    Mayuri155 pointsBadges:
  • Excel 2003 toolbar functions greyed out, but not Excel 2007

    I bought a new laptop which has a trial version of Office 2007. I have been using Office 2003 on this macjhine for a few weeks, & suddenly both excel 2003 & word 2003 have most functions greyed out, and excel and word are unusable. Excel & Word 2007 work fine (no protection is on). Could Office...

    Trevor1c5 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:
  • Excel Calendars

    I have a schedule and would like to put the current months calendar as well as next months with cells that I can add info to for each day. Currently someone has to update the dates from month to month. Is there a way to have the calender update by just changing the Month and 1st date?

    Sandman00730 pointsBadges:
  • Microsoft Excel 2010 macro help

    What I have: this is one transaction in a parking garage. 4 columns, 3 rows Date/Time     Movement          *blank*               Ticket Number Facility         *blank*               Car Park             System Device Card             *blank*            ...

    MrJoe12135 pointsBadges:
  • Biometrics

    I have to give a seminar of 20 mins regarding boimetrics, so please help me as in which sub topic in that should I choose. Please help me with the link where I can find info also about it.

    Bganupama5 pointsBadges:
  • Excel 2007 – formula or macro to show value from one cell next to a given reference

    Hope someone can help. I am trying to work out a formula to place the value of a cell on a spreadsheet into a second sheet within the workbook using a reference in the column next to the cell with the value in it. EG - Sheet 1 has a cell with £500 in cell 3A The reference 1.01 is located in cell...

    PeteAtGlasshead5 pointsBadges:
  • Formula Assistance in Excel xlsx for Office 2010 w/ Windows 7

    I need to know which formula I can use that will produce the following result with the following existing data: Column A, Row 2 - (Cell A2) - Value is 200806140804 Column A, Row 3 - (Cell A3) - Value is 200806150805 Column A, Row 4 - (Cell A4) - Value is 200806160806 Is there a formula I can...

    Mommiek10 pointsBadges:
  • Excel 2007 what is the command for scrolling down your rows with still seeing the header row at the top

    I know this is so simple but what is the command for scrolling down through rows in Excel 2007 but still keeping the header (titles of the columns) in view. Thanks so much!

    Buddyboy12310 pointsBadges:
  • Convert Number value in text string

    I am using Microsoft Excel 2007. I want automatic conversion of a number value into relative text string. It means if I have "687" into one cell, then it should be converted into "Six hundred and eighty seven" into next cell. Please guide me for this.

    Makkes5 pointsBadges:

Browse Alphabetically:

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