HI,  I am using the new 2007 Beta 2 from Microsoft Excel, the problem I
am having is that the Hyperlinks I used under 2003 were instant when
you clicked on them,  Using the same files in 2007 I have to hold down
the Mouse button for a few seconds in order to activate the link

I have exported from an Order Entry program to comma delimited text file
customer purchases. The file has more entries than Excel can handle on one
worksheet. So, I imported the file data into Access (107,000+entries). I
then used Excel's "Query Database" feature to import ...

I have a column with formulas, and when there is no data to calculate I get
a #VALUE! I would like to hide #VALUE!
Can anyone point me in the right direction?
Thanks

Help!  I am a novice trying to modify a worksheet that someone else
created.  I am baffled by something that I can only describe as a
"floating" cell.  Essentially, it is a cell that has several different
assigned values that change when it is clicked.  For instance, "1"

Group,
I'm sure it must be, but is it possible to use some function which
returns not the contents of the specified cells, but the cells
themselves, as a reference or input to another function?  The reason I

I dim Warning(100) as string
Then I do the following:
Warning(1) = Cells(1, 3) + " " + Cells(3, 3) + " " + "Assessments" + "=
" + Cells(2, 13) + "," + Cells(2, 16)

I have got this macro to run when opening.  All works, but when I password
protect the sheet,  and then close and open i get a run error.
I am not fluent with VBA and get by by recording and pasting other work off
the treads

I am trying to import data from MS Access but it comes as rows i
excel.
Is it possible to while we importing the database into the excel
we change the rows to columns and data still get synce with databas

I have two conditions
1. m2>0
2. =M2-P2<3
It only pays attention to the 2nd condition. As if its and "or" rather

I've spent a long time making a new spread sheet in a new workbook and just
deleated it. Is ther any way to recover my work or must I start over?

Is there a way to use validation over multiple sheets? When I select
several sheets in a workbook validation isn't offered under Data. I was
hoping it would work like formatting over multiple sheets.
John

I already do this using a macro but thought it might be possible with
just a cell function.
Column B has either 1,2,3, or 4 in it. These are service codes. Column C
has hours in it. I want total hours per service in another place on the

I have a Task Account
I use lookup feature with a category list on a separate sheet. OK, so
far.
Right of the category drop down list I have drop down list to choose

im making a timeline plan for school, and when i enter the date such a
3/2/06 it autocorrects it and changes it to 03/02/2006 which i dont hav
enough room for. is there a way so it doesnt automatically change it?
and the other is ive already typed up my table, disregarding the fac

Urgent !!
How can we abe to save the worksheet and at the same time still able to
protect the VBA project coding for viewing ? This development is just like
creating a Template with many macros programming and you do not want the