I set up a shared workbook that included some data validation.  Now I
need to add an additional valid value but when I go to Tools, Share
Workbook, Editing I cannot turn off "Allow changes....) so that I can
change the validation.   It is OK if I lose the change history up to

I need to convert an excel 95 spreadsheet to excel 2003.  got any tips,
guidence etc.
Bach

I have two workbooks. Workbook A has multiple worksheets. Each of the
worksheets represents one week of the year. For example, worksheet
"week ending 7-30-05" has data for each day of that week. Row 1-5 of
the worksheet has data for 7/24/05. Cell "A1" shows the date, 7/24/05.

How do I prevent excel starting a new instance of internet explorer whenever
I click on a hyperlink in a spreadsheet.
I have a spreadsheet with 3000+ rows. Each row has a cell with a hyperlink,
so the instances of IE can build up very quickly.

How can I trim the last space from text but leave the other spaces intact
ie:-     Red Lancer (IRE) Red Lancer(IRE)
Torrent (IRE) Torrent(IRE)                                                  
Sir Edward Landseer (FR) Sir Edward Landseer (FR)                            

Hello all--just a quick question from a frustrated Excel user.  How do I
prevent files from automatically opening when I initially open the Excel
Program.  I consistently have 2 files that open whenever Excel is
initiated!!! Driving me crazy!  :eek:   Short of deleting these files,

I have two worksheets with contact data entered in rows. There are roughly
300 rows in Worksheet A which are also present in Worksheet B. I wish to
compare the worksheets for the purpose of eliminating the rows present in
both worksheets.

I've set up auto filter. For some columns I have Validation rules for whole
column (can be relevant). I have 4 rows entered. But, when I filter some
column the next row after the last filtered row can be # 15. So, when user
filters the column and enters data into the first empty ...

I would like to enter a company name, such as "ABC Co" in a cell o
sheet1 and then on sheet2 have a cell with text "Proposal for ABC Co".
I would also like to be wildly rich. Can anyone help with either o
those

I am creating a workbook that tracks different types of employee hours.  The
workbook will be used by the supervisor to make daily entries that are
summarized on a monthy basis.
I want to create a pivot table on each of the worksheets that automatically

Hello I got this date 2005345 which means year 2005, week 34, day 5
I want excel to format these values 2005345 and only show W34
How is this possible?
/Anders

How do I set up workbook to open on specific worksheet every time?

I have a list of 150 assets which are assigned to 20 or so depts. How can I
count the number of assets per dept. In essence counting the number of times
different values reoccur? For example
Asset1 - dept1

I have a question about how to write a formula to include specific info in a
range of cells.  I have a range of cells I want to include in a formula but I
want the formula to only include the values that I have colored Yellow.  I
could select each yellow one by hand but I want ...

i have a cell with a formula in one worksheet that references another
cell. the formula looks like this:
=IF((ISBLANK('Draft'!$D25)),"",'Draft'!$D25)
where 'draft' is another worksheet in my workbook.