I have 2 sheets. Sheet 1 has 50 rows of data and Sheet 2 has 14 rows of data.
I did a VLOOKUP on sheet 1 to find the matching rows on sheet 2. I filtered
the VLOOKUP with Customer> does not equal>#NA. Now Sheet 1 shows the same 14
rows.

All of the sudden, formulas are not calculating.  This is happening in
completely different spreadsheets.  Its as if they aren't calculating.  For
example, I have this formula =SUM(E4:E38), and its returning a zero.  And
yes, I have numbers in that range. :)

Have received a long list of names and email addresses in a CSV file.
I would like to use the email addresses directly from the spreadsheet, by
clicking on the cell where the email address is. I am sure that I used to be
able to do this, but now it doesn't appear to work.

Is it possible to protect just some cells and not the entire book?
JPG

Anyone know of a free Excel password recovery program?
Cheers,
D

How do I prevent the macro warning from popping up while retaining the medium
or high security level?  Is it possible?

We can change the font color by clicking on the color panel and then when we
type information, the data is in the font color, HOWEVER when we press the
<Enter> or move off the cell, the color changes back to black.
Per opening up a spreadsheet which others have applied color to ...

I work with a system that can export information to Excel, but I need to
change the format of two fields each time.  Currently, dates export in format:
mm/dd/yyyy hh:mm
and work estimates export in format seconds (ex: 2 days or 16 hours is

I have a Zip Code Table with numbers with 9 digits or more showing up.
How do I go about only allowing the field to show the first 5 numbers and
dropping the rest after 5?

Is there a way to delete a sheet and supress the message asking if you
really want to do it.
Thanks,
Craig

I need help in writting  a command in my file.  I would like for a name to
print out in a certain color, when a certain amount is obtainned.  Can you
help me with this?

Can part of a formula - which is a defined name for another cell - be changed
by a find/replace function?

Excel 2007, windows xp sp2
I would like to create an excel file with multiple worksheets in the same
workbook that break down data by month, week, and day. On one main page I'd
like to have "frames" (similar to web page frames that are scrollable on

May     Jun     Jul
Apple      No       Yes     No
Pear       Yes       No     Yes
Orange   Yes      Yes     No

Is there a way to identify the source data for a pivot table?  I have many
worksheets in a workbook, and several sheets containing various pivot tables,
and I would like to confirm the data source when I'm looking at a pivot
table.