Workbook A has a cell that gets data from workbook B as an external link.
It does this using the indirect function because it needs to concatenate the
path and filename from other cells.
Problem is that if workbook B is closed, the cell in workbook A shows #REF!.

all but the last 4 digits in a column of numbers

I have three sheets in my workbook: Request sheet with request number
and date,Fault  sheet with request number and faults count,and in the
third sheet I have month start date and end date. I want to retrieve
data such that : sum of all the faults of those requests which fall in

How do i get the excel programme to give me a confirmation sound when i have
saved? (cntrl+s) so i dont need to look up to see if its saved the data.

Using Excel 2003
I'm trying to modify my Normal style so that when I type text in a cell, it
gets default-positionned in the top of the cell.
When I do it through Format /Style/ .. and modify the Normal style, it works

I have an excel spreadsheet which contains answers to a survey (man
rows of columns of answers, each column is the answer to a question)
Each cell in each column contains one of the following answers;
1-    Yes

hoe rekenen je met excel

What is the formula for: the letter x = 3.7 for a possilbe grand total of
100% once all values are calculate

Column G has a conditional format for Green, Yellow, Red depending on
the content of G, Y, R. It serves as a "Stop Light" indicator.
I need to force this to upper case or some of the other cell formulas
do not work. (it recognizes G but not g etc.

I need a script to remove every other line in a excel document, starting at
say line 10 and delete line 11,13,15 and so on is this something that can be
done.
Thanks for any help

I have a simple inventory form with headings and a few simple formulas.
The problem is this. One formula is the following =COUNTIF(C6:C625,"*")
indicating Total Items for that column. The the problem is that if I
look at the end of the actual column, the number is different. Right

please,tell me how to type and record all the details on my computer.I am a
new computer user.

I really wounder how good Excel really is. I have for some years now worked
with a simple worksheet where I register my hours of work for all the
prosjects I participate in. In my workbook I have a sheet for all the months
in a year where I have a date, project, activty and ...

I have a user on our network who can not open files directly from her
folder.  She can open the files from within Excel.  I have checked her
network permissions and everything seems to be correct.  I have also check
the file assocation on the workstation and it too seems to be ...

Can someone tell me, is there an easy way to fill down the first colum
with consecutive numbers?
Thanks
Jame