We are trying to limit the number of users that are able to open and work on
an Excel Workbook at the same time to one at a time.  Is there a way to
configure the sheets to do this?

I have an excel workbook I use as a template for projects.  It has several
hundred hyperlinks to files contained in 4 directories.  When I set up a new
project I copy the workbook and the directories to a new location.  Some of
the hyperlinks update to the new location but most ...

I would like to compare range A to range B net out differences using
conditional formatting - differences shown in bold red font.  How do I retain
range A with the result format when range B is deleted?  I'm using Excel
2003.  Thanks!

This is what I am trying (with little avail) to do:
I would like to write a code for a sheet in a workbook that will
search through a particular column, lets say A, to find any values
greater than 30.  Every time it finds a value greater than 30, it

I have a macro that looks in a col and and find what you asked and copy it to
sheet3. What I want is the macro instead of copying to sheet3 paste it on top
of sheet1 and delete the copied cell and bring the rows down. Something like
you sorting for value. for example, in sheet1 col. ...

At work I've inherited these files which contain lots of graphs. Some
of them seem to be linked to files that no longer exist (in Edit /
Links I can see them, of course). However, I can't find where those
links are, in my files. I'm pretty sure they are in the graphs - not

I have a worksheet with a UDF that displays the last saved date. There are
other cells which have dependancies on this date. When saving and reopening
the document the date remains unchanged. I have tried F9, Shift + F9, CTRL +
ALT + F9, CTRL + SHIFT + ALT + F9 and also changing ...

I want to enter some vb to a Workbook_BeforeClose option that automatically
clears any filters in a specific sheet as the workbook is closed. Example of
recorded code is below which works but I have the sheet protected so I do not
believe below code is optimal for a protected ...

I have a relatively complex workbook (by my company's standards
anyway), containing a number of Protected Sheets.  These sheets are
manually protected (by me) before publishing, but I've also included a
Workbook_Open macro (in ThisWorkbook) in case I forget to protect the

I can't get external data with an ODBC connection to SOTAMAS90.
I can bring a XL 2003 to XL 2007 with the functionality intact from 2003
spreadsheet - but I can't  create a functional XL 2007 new query.
Are there any sources for guidance?

I am trying to create a connection or reference between cells on different
worksheets within the same workbook that will automatically propogate as data
is changed within the ference cell.  I am using Excel 2003.  Hope this makes
sense and someone can help.  Thanks!

I need help in trying on what I think is a validation issue. I'm
trying to get excel to prompt the user to enter information in cell B1
if cell A1 contains data. What would be there formula?
Thanks for the help.

This has got me really scratching my head.
I have the following formula in a table:
=IF(B26>=25,"",IF(G5>=G50,"YES",""))
The problem is thatt B26 is less than 25 (8), and so the answer comes

Hello -
I have a list of expiration dates and I want to highlight the expired ones.
The list is tranposed from another sheet so it is in a column instead of a
row, so I want to be able to do this without sorting.

Does anyone have a formula they can give me to count the minutes between the
two columns below?  
Dec.19.2007 21:36:23      Dec.19.2007 21:41:07