I have a problem with my MS Excel 2002 (actually it exists in MS Excel
97 too). Every time I'd associated a hyperlink with the text inside a
cell, the font will get change e.g. from Arial (size 10) to Arial (size
7). How can I instruct Excel to keep the original font setting without

I am looking for a way to convert linked cells to their actual (fixed)
values in a workbook which is password protected except for the cells I
use for linking. Would need macro which would find all non-protected
cells and do something like copy>paste>values.

I have posted this question in the Excel area but have not recieved any
replies, maybe someone here can help.
I run Win200 with Excel 2000. I have a spreadsheet that is protected. Some
of the cells are not locked so that information can be entered into them.

The standard "Import External Data" function in Excel makes it easy
enough to obtain a single record in Excel from an Access database, but
I'm trying to figure out how to use a figure in the spreadsheet in the
MS Query.

I need to use Find and Replace (Excel 2002) to modify a lot of formulas. Is
there a way in VBA to disable the recalculation of each cell after the
formula is updated? It's taking forever!
I tried the follwoing but it does not work:

Is there a reasonably simple way to link a range of cells in Excel to a
table in Word such that the word table is not messed up by adding a
line above the cell range in Excel?
If I've linked a 5 x 3 table of, say B5:F8 to word, adding a row above

I use excel to make up lists of keywords.
I enter a different word (or several words) to the first
cell only in each row, but as there can be hundreds of
rows, I'm looking for a quick way to identify (back

My spreadsheet contains a matrix of data in four columns by approximately
600 rows. The data is structured as follows:
column A = start date
column B = start time

HI,
I have recently discovered a problem with my copy of excel When I try and
break a link from one spread sheet to another my copy of excel crashes and
then recovers the data. I have tried reinstalling windows office xp but this

I have two spreadsheets. The first spreadsheet contains two columns, one for
start date/time (in serial format) and the second for stop date/time (in
serial format).
The second spreadsheet contains two columns. One containing a serial

Can someone please help me to make this formula
=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))
not to count blanks
i need to count nubers that are the same in the same row

i have excel 2002 and Win XP. I am creating two lists of name one line of
travel and one alphabetical. I want to know if there is a way
a)    to link the two together in a way that if i change the sequence number
on the   travel one it will automatically change the  number to the

www.excelhelp.tk voor uw problemen met excel

I run Windows 2000 & Excell 2000 with service pack 3.
I have an autoshape button that I have added a hyperlink to which opens a
html file on a server.
When I add the hyperlink and press the autoshape it takes me to the file ok.