I am building a report spreadsheet  that links into and pulls
information from another spreadsheet i.e LabourWk49.xls.
I have quite a lot of links into LabourWk49.xls and wondered if there
was an easy way of wholesale updating the weeks so the links can be

I have a formula in a cell.   =SLOPE(ref1, ref2).  It compultes a numeric
result with no complaint, which appears to be reasonable/valid to me.
Now, if i edit the function name ONLY and change it to LINEST (stuff inside
the () stays the same), i get #VALUE.

Can someone please help. I am trying to understand how VBA can be used
to get data from one sheet to another. I have some code that works but
I think it could be a bit better.
With regard to the code below, the queries I have are as follows:-

I currently have an excel 2003 workbook that I set up to keep the old
checkbook current.
set up like this
a                b               c               d            e

Hello group,
I have the feeling that the answer to this question is going to make
me feel silly, but I really can't seem to work it out using either the
Excel help file or online documentation. I must be looking in the

Recently I got excellent help on how to fix my dates which were entered
improperly. Worked like a dream. Now I need help on how to resolve the
current problem.
I have the old date column A - ddmmyyyy

Can I place a shortcut icon to the Excel Help menu on my desktop?
If so, how?
(Perhaps, Excel must be opened for this to work?)
Thanks,

I've made a spreadsheet with several tabs.
In this sheet i've selected a certain print range so only the
information i need gets printed.
But when i try to print the sheet, or on the print preview everything

Excel is Autosaving while i write this.  Already has been for about 3
minutes.  I can tell it hasn't finished by the fan on my laptop and
processor is 100%.  Its INCREDIBLY hard to be productive when you are
suddenly stopped from using Excel for, literally, 5 minutes, at random

During development of my school project I have found a bug (in my opinion).
Writing formula 5-10^2 I am getting as expected -95, however changing order
of summation to -10^2 + 5 I am getting 105 (which is equivalent to (-10)^2 +
5 not as intended -(10^2) + 5). I think it should ...

I have created a workbook sheet and want parts shaded. It will not print the
shaded part. Help?? I am running Office for Mac

I have a need for a look-up table function in Excel.  The look-up functions
are combersome for my particular application.
I can create a table, for example prices, with several named rows and
columns.  I need to find values in the table based on imported data which

Looking for a formula where cell E1 will add cell A1 to the lowest total
from cell  b1 c1 or d1, then the same with the formula but this time with
the highest value.
Thanks again to all who reply.

I have a named data base and want to name the rows columns and use those
names to return the intersecting value. I named the array without a problem,
but I can't seem to get the rows & cols. named to use in a formula.
I have 2003 with SP2

I am trying to use a formula or function that will look at a cells say column
A check for a condition, if true, then add the value of another cell that is
on the same row to another cell.  Yes I know that may be difficult to
understand so let me give you an example.