I have a question on "connections" in Excel. I want my data file to b
connected to a cell in an other data file. This is no problem.. but th
problem is that this connection will get a setted path, for exampl
C:/documents/target.xls

Does someone know if there are limits when dealing with matrices? I get a
value error if I try to calculate the inverse of a large matrix (68x68
cells). It works up to 52x52 matrices but fails when the matrix is of size
53x53.

Is it possible to have the contents of a cell auto save into the file name?
E.g. if I have a clients name in a cell, I want the name of the file to
change to match that cell so that when I quicksave the file name changes to
match that particular cell.

I have a 200 x 100 matrix.
Down the side in column A I have clients and they are Tier 1, 2 or 3.
Across the top in row 1 I have products, and they are rated A, B, or C.
Then in the 20000 squares there is a value (corresponding to their sales

When I use the =Char(189) formula in Excel, it returns 1/2.  I go on
Microsoft's website:
http://office.microsoft.com/en-us/assistance/HA011331361033.aspx
and the code for 1/2 is 171.  Can anyone tell me why this is?  Can I use a

I am creating a distributioon table of data and would like to have exel count
how may time a number between a range apears.
for exsample  if I sell  100 apples  for diffrent prices i want a formula
that will calculate how many of them were sold for $1=<>3.

In column A I have an ID number which can repeat a number of times. In
column B I have Dates eg:
A        B
xyz        02/05/2005

Due to the unknown cell value in some cell, I have some cell come u
with "#VALUE!" in the side.
Is there any functions can delete the "#VALUE!"  value?
I try the if statement, but fail&#12290;

how can i change the row from 123 to ABC

Hello! :-)
I am trying to create a calendar calc tool that, when I work on a sheet, it:
1) Automatically loads today's date
2) Automatically loads number of pay periods remaining in the plan year

I have a table of relationships - where an item can relate to one or
more items. Specifically, these are systems and their interfaces.
For example, System A relates to (shares info/data) with System B which
also has a relationship with System C. I want to generate something

Is there a way to refer to a specific cell from the page header WITHOUT
using VBA?  Thank you!

If I want to know if a something has not met the due date set in my
spreadsheet, can Excel send me an alert in some way?
Or can the cell become flagged when the date is not met so it can be easily
detected?

This is strange.  For some reason, I no longer can delete columns (or rows).  
The "Delete" option under Edit doesn't appear anymore.  In searching to
figure out what was wrong, I noticed that "Columns" and "Rows" are no longer
an option under Format.  Anyone have any clue as to ...

I have a formula, due to unmatch data from another table, some cell has
"#N/A" show up, how could I replace #N/A with [nothing ""] in the cell?
I try to use the if function, such as
=IF(A1="#N/A","",A1)