Where is this option in 2007, can't find it?

I'm using Excel 2000 on Windows 2000.
trying to create a new database query and in the status bar it says:
"waiting for data to be returned from microsoft query" and hangs
What's happening?!

Hi i was hoping someone could help
what i have is column "A" which has a list of days in the form monday,
wednesday etc.  Then i want column B to display the next day.
               A                    B

I've been tasked with updating a 14 year old excel macro running on a
15 year old mac :(.  I'm running into problems with the replicating
the charts.
Heres an example:

Here is my sheet. I go out Jan 1 @21:00 and get back Jan 2 @09:00 then
the next day out @09:00 and back in @21:00. Is there a way to write a
formula that will  do nothing if C2 is empty then go to the next Day
( C3 ) and  count the hours for D3? at the same time if i was to go

Hello group,
I'd like some help drawing a trendline in Excel.  We have price datasets
going back five years that we want to chart using a line, with an
accompanying trendline.  The trendline should be a moving average that uses

Using Excel 2003 on an XP machine.
In Column A, I have teams listed as follows:  Team 1, Team 2, Team 3, . . .
Team 10
When I sort this column, I get Team 1 followed my Team 10  followed by Team

I got an xls file as I wanted, I then "Set Print Area" to be A1- I42. That
looks good when I say print page, so when all done,  I did   Save As -
Model.mht    and closed Excel 2003.
When I open Model.mht, IE6 opens , BUT the info does NOT take up the

When I create a command button I can do all of the below except set
the FontStyle.  What is the correct syntax for this?
  With objActiveWkb.ActiveSheet.OLEObjects.Add("Forms.CommandButton.
1")

Luckily for me the 'sheet in which the following occurred was not a
biggie.
I'm very much a spreadsheet novice and hope the following helps
somebody else.

I have a spreadsheet with the VBA protected. when i click on the file
name in the vba project window, i have to type in the password to
expand it to see the sheets and modules. i have another spreadsheet,
and have the vba protected, but the protection seems to not work.

I want  to restrict duplicates names in Col B.I forgot how to do that using
data validation. Can someone help.Thanks

I've tired =j6+g21 but from different sheets, so its possible when i change
one the other changes also. What formula do I need, because thats just not
working

I wrote a while back and was possibly not clear - I do a lot of data
import and clean up - on this new computer, the subject topic, which I
call data parsing, does not work correctly. I have to divide the columns
with one extra space, which I never had to do before. I hate to ...

=VLOOKUP(A40,'WITH GOOD'!$A$2:$D$1000,2)
Is there a way to show "blank cell" instead of #N/A in the cell
"A40"?
Thanks