I have to edit an existing spreadsheet with an index and want to have an
alphabet listing at the top so
that when you click on the letter you're linked to the first cell in that
section that starts with that letter.  

I am using Excel 2007 and I've used to use the auto back built-in with Excel
2007. I've found the Excel 2007 creat a backup file from the file I am using.
How can I change the path where Excel save the backup file.
Thanks

I have a checkbox in E5 controlling E5. If I copy it to K11, I want it
to control K11.
Now, how do I give it this kind of relative reference?
Thanks, Sven

Could someone please do this formula for me.
£300,000   to work out its worth each year (including interest)  Then deduct
cost of living % (inflation) each year.
So £300,000 (at 6% interest) = £318000  deduct (inflation at say 3%)=

We got a accounting spreadsheet via e-mail from a client which contains a
lot of formulas.  This file can be open by all the computers;  however, one
two computers, the cells show #NAME? instead of the numbers.  All the
computers have Office 2003 SP2 (we cannot install SP3 ...

When try to sort by date column, with some cells having dates created by
reference/link to anther cell not in the same column, the sorted cell/s
changes to a reference error (guess thats what Id call it, not sure what the
official name is)  =#REF!

I have written an extremely simple function in VBA module for sheet 1 and
when I try to use that function in a cell in sheet 1 I get a *Name? error.  
Has anyone seen this before?  How do I get the function to work?
Function CalculateOne (a,b)

When I copy and paste into a blank cell my borders from the cell dissapear.
What am I doing wrong?

One thing that drives me crazy is that I want to work on files at
home, but when I bring them from the office to home and work on them,
when I get back to the office, the full path names of the sheets I've
worked on are saved.

How do you do a stacked column chart with 2 stacks and 1 line above
the columns plotting values. This line doesn't touch the columns.
This chart has 2 axis.
Thanks for any help on this.

Thanks for the answers on my previous question. I ended up not using
them (those formulas are far too complex for a dabbler like me). I
created two columns to find the origin of either "http://" or "http://
www." (always "1" if found), multiplied that by either 7 or 11 to get

A1 has a date value in cell D2 I want to obtain the day (i.e. is it Monday
or Tuesday....).
Is this possible??

(XL2003, XPPro,SP2)
A few years ago  I'd added an add-in to XL2003 (don't remember what it was
for, but I recall always seeing "FUNCRES" appear for a few seconds at the
bottom of the workbook as XL was opening).

I have a piece of code that doesn't respond to error handling:
On Error GoTo question_end
 secondblank = Range("a" & firstqunw & ":a100").Find(What:="",
LookAt:=xlWhole).Row

I'm connected to SQL and I'm importing the results of a query in sheet1
using  the syntax ORDER BY. The query and the import are working fine,
however, the data in sheet1 is not ordered as in the query. How can I
maintain the imported order on sheet1?