I can pull in a value from another spreadsheet with this:
='T:\Operations\IT\IT Shared\IT Process Engineering\Resource
Allocation\PM\[PM Data Entry.xls]CDH BLUECHOICE'!$M$194
If I copy the above (minus the =) and paste it in cell AB3, then why doesn't

Why do totals that are grearter than 100 get ####
How can that be changed

I am looking for a formula, as opposed to a VBA solution, where I have a
column of text entries, but with empty cells interspersed here and there
from top to bottom sort of like this for, say, cells A1:A6:
House

I have an excel sheet with 6 separate ranked charts on it. I am able
to sort 5 of these charts in descending order. Excel will not allow me
to sort the 6th chart in the same way. I keep getting a "This
operation requires the merged cells to be equally sized" message.

Is there a way to have a formula that is copied across colums refer to the
source colum (which has data in each row) as "absolute" but "relative" to the
rows on the source column?
Example

how would i be able to hide part of a sheet that has formulas on it. i would  
like to email this sheet to others but do not want them to view the
calculations?
thanks.

Hi hope you can help!
I have a serial number which is made up of a three letter prefix and
four numbers.  The letters are area codes which there are only four
variations, numbers are random. I have used a Left() and IF() function

I downloaded an xl template worksheet which has links to MSN Money website
(for updating stock prices)
As I have xl97, and the worksheet was created in a later version, I saved it
as a xl97 worksheet.

I beg your assistance.
I posted this last year, and reread this recently. I've come to
realize how crappily I described this, and thought I'd give it another
go. I have the need to take 2 dates, possibly in different years, and

I have been handed a list that I need to convert and I am stumped.
The worksheet contains three columns of addresses. The addresses are
generally in one of three formats:
Company

Can anyone help me with the following: I need to display stars (*) in the
cell instead of numbers, meaning that when I enter the number 5 in a cell I
want to show 5 stars (*****) instead of the number 5.
Thanks

I understand that Excel protection is not that strong for determined
people to work around. Are there any 3rd Party software that users
have used which encrypts Excel to a relatively satisfactory level? I
still wish to use and distribute Exel files but with a stronger

Excel 2003. In a cell, I have a formula that computes sales tax and gives the
resulting tax amount. Example of resulting amounts are 1.67, 1.83, 1.40. In
the case of 1.40, excel is displaying 1.40 because I set the formatting for
two decimals. However, the actual figure is 1.4. I ...

I have a spreadsheet of about 50 rows.  I need a way to copy the text
in say row 2 and make two new rows under it with the same text as in
row 2 right under it.  but i want to do it for all the rows.  any
ideas?

i am sure this topic has been addressed but i cannot find anything on
a search
the problem is that the office clipboard will not copy a value which
is the same as one already copied