I get the message invalid ext reference when I am trying to replace a link.
I have deleted some of the sheet of the feeder sheet but I thought I had
already updated those where the reference had been deleted?
How can I get round this problem?

Is there a way to search an entire column for specific information? (Ex:
search a column for the word "item") Then, display the word I searched for in
another sheet? After displaying the result , is it possible to display
specific cells in the same row the word was found in excell?

When I opened up the excel file, it prompted me to
plugin password. There is no read-only option too.
how can i open it up, i tried download some password
protector software to crack it, it is only limited demo

Some how I got set up so that when I paste text into an excel sheet it
auto does the text to columns funtion. Each word is in its own cell. I
would very much like to know how I got set up in this way and even more
how I can stop it. I have opened new sheet and books and the same ...

Can I make a whole line go red, if one column gets a higner number then 26.
That one column add´s up 3 others and when it hits 27, I want it to make the
whole line red.
Is that possible?

I have this problem
I would like to change a column format from (m.d.yyyy <== date format) to
(m.d.yyyy <== string format)
Any method I can use ?

Does anyone know a good site where I can hire someone to create what
want?
Basically I want to create one main loan pipeline that when I clic
update will go into each loan officers folder on the server, pull th

Hi there, I need some help with Excel.
I have a function as below, where "1" and "2" and so on corresponds to
4 different numbers.
1          52

please help

I have created a spreadsheet and saved it to a network drive.  I have not
applied any sort of protection but when others try to open the file it shows
as Read-only.  This also happens in reverse order; when I open a file created
by a co-worker it shows as read-only for me.  Why ...

Okay, this is BASIC and I feel bad for asking, but I can not get my
count to work.
I have a spreadsheet with a list of doctors names and other
information, I tried to do a count on the column using the following

I want to lookup 2 items for a match to enter 3rd item.
EPP          2.80            x?        want A3 to have a lookup function
that matches both A1 and A2 to the array.
EPS    1.25    0.5%

Hello Friends,
I need some assistance in solving a problem.  I have a spreadsheet with
over five hundred lines of transactions. The sum of these transactions
are creating a balance on the account. Is there any formula/macro that

I have the cell return wrong value
ie. M cell returns #VALUE!
where M cell forumla is =SUM(I2*AU2)
I2= 20871

Guess I don't understand pivots like I shoud! (Yes, books are on the
way)
Anyway, data looks like this:
SubmittedDate    0-15 16-30 31-45 >45 PxAmount