Did all my tests with Excel 2007 B2TR in publishing spreadsheets to MOSS 2007
Excel Services and using the Excel Services Options.
Removed B2TR and Installed Office Professional 2007 download from MSDN and
now the Publish options list does not have Excel Services as an option.

Is there a way to automaticaly sort data. For E.G. I have a list of venders
with their names in column B, Telephone No. in column C, Addresse in column D
and so on. And then when I need to insert a new vender I want to use a macro
to insert a new line in the top of the list, put ...

How do I set criteria to sum only on filtered amounts?

I had a lesson that had me to build a Book.xlt. I deleted it from the XLStart
up but when I open a new woorkbook it still opens wit one sheet and when I
push shift+F11 it still adds the sheet I created but there is nothing in the
XLStartup file. I don't know how to change it so ...

Home -> xl2kPro, Work->xl'03
I routinely create macro's for various functions (Personal.xls) and export them to/from
work - no problems there
I also create custom button images and would like to export them as well.

Hi Gurus
I am not a VB programmer but I know where to write code for worksheet
selectionchange.
I want to run a macro on entry in any cell of column "A". in short I

I have a cell in my Sheet which shows the last updated date ( E11), Now i
have macro coded which sents  email from Macro if the difference last updated
date and todays date is more than 2, I have a cell E12 where I enter todays
date and my Email macro gets activated, my email ...

I need a way to track patients by name, SS#, etc., (using columns), that will
allow me to constantly update/edit the template while tracking abnormal lab
results--I need also to be alerted when a patient did not keep a scheduled
appointment (by a red flag or something).  Help!!

Has anyone got the error:
"Excel has found unreadable content"
and then
"Removed records: PivotTable report from

Despite changing the setting under Options/General where I uncheck the box
"R1C1" every time I open Excel, it does not seem to store my setting
permanently.   How can I permanently undo this setting so that I work in "A1"
mode?

Excel 2003 help tells me I can use HEX2DEC to convert hexadecimal
numbers to decimal, but when I try to use it in a formula
=HEX2DEC(A2)
Excel changes it to read

Can someone tell me where i could find a template for dupont formulas?

Hi I want to write a macro code to retrieve the value in a Cell in Range( B1

The Value should be displayed in a Range ( A1: A20) in a differnt worksheet
of the same file

Can I change the number sequence?  I would like to combine 3 rows and have
Excel only number it once but not to wrap so each cell is individual.

How do I control printing headings on some pages and not on others when
printing multiple pages?
Thanks in advance
Danimal