1
  • Recipient list

    Not all my recipients from my Excel document are in my mail merged document

    LynnMT5 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:
  • 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 startup

    something odd has been happening with my Excel for some time and I haven't been able to resolve it. It's not serious but, annoying. Whenever I start Excel I receive an open error that goes to temporary directory to open a file named SaveDBFIV(1).xlam. I always reply "ok" and open the file I plan to...

    LeChat80 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 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:
  • Deleting successive rows on Excel 2007

    Using VBA in a large timeline excel worksheet of 50000 rows. How can I automatically delete every 3 rows and leave the 4th row so I can reduce the number of rows to about 12,000.

    Debress5 pointsBadges:
  • Sending Excel 2007 spreadsheet without calculations

    I want to save a copy of my spreadsheet to send to someone, without them seeing my calculations. I need to convert the equation, save the answers as they appear in number format. I know there is an easy step but can't find the terms to search it properly. (Excel) Can someone please assist me?

    Matilda5 pointsBadges:
  • rows don’t line up or text does not appear with excel 2007

    I have instances where the rows (left freeze panel) do not line up ( and right panel)!!! sometimes the text does not appear on the screen, OR looks like it writes over itself. Happens when i do a control f to find text usually but not all the time. Anyone else having this problem?

    Peasandcarrots5285 pointsBadges:
  • Unable to Refresh Pivot Table if Datasheet in Excel 2007 is not open.

    I have several Pivot Tables linked to several like spreadsheets, respectively.  When I refresh a Pivot, I get an error that excel is unable to open the file (that the table is linked to). If the file is open, I can refresh.  My problem is each spread sheets contain huge amounts of data. Is there...

    Skb195510 pointsBadges:
  • Graphing Challenge in Excel 2007

    I am working on a project, and was wondering if there is a quicker/better/easier way to do it than what I have been doing. I have two sets of data - one for 2009 and one for 2010 - broken out by department (there are about 100 different departments with which I am working). The data sets contain...

    Mchel275 pointsBadges:
  • View row labels as column headings when scrolling in Excel 2007

    Row 1 contains the column labels, when scrolling the A, B C column headings are replaced with the row names. It is not "freeze" situation.

    Onthemove5 pointsBadges:
  • How can I e-mail data to be viewed in Excel?

    How can I e-mail data, to be viewed in Excel, from a programme written in VB6, so that when the recipient opens it, the Excel workbook shows not only the data, but copies all the formulae, eg. Totalling columns etc. and the formatting, eg. colours?

    Martinyk10 pointsBadges:
  • Matching Items in 2 worksheets

    This is probably incredibly basic and has a simple answer - at least I hope it does.  I am using Excel 2007. I have 2 worksheets run from 2 different systems.  The systems are supposed to have the exact same information, but unfortunately Sheet A has 1350 results and Sheet B has 1365 results. ...

    Natoma5 pointsBadges:
  • Unable to view Excel 2007 workbook

    I have open a workbook, but unable to view it. When I attempt to reload, excel ppoup ststes already open. The workbook has macros. The VB editor shows them, therefore the file is open.

    Jhengineer5 pointsBadges:
1

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