Using Invoice template: overriding formulae
 

I am having a problem when using the Excel 2000 Invoice template. Sometimes I
enter text into the 'Quantity' column. Then Excel is unable to calculate the
Total, in the blue shaded area.

My question is: How do I override the formula calculation in the shaded area
to simply enter the numbers and/or text of my choosing?

WTIA

Andrew Stucken
--
Evil flourishes when good men do nothing.

Using Invoice template: overriding formulae
 

Don'y know how to override the original protectiion. Easiest would be to copy
and paste into new sheet and use this to create your own template.

Roger

"Enigmaman" wrote:

I am having a problem when using the Excel 2000 Invoice template. Sometimes I
enter text into the 'Quantity' column. Then Excel is unable to calculate the
Total, in the blue shaded area.

My question is: How do I override the formula calculation in the shaded area
to simply enter the numbers and/or text of my choosing?

WTIA

Andrew Stucken
--
Evil flourishes when good men do nothing.

Using Invoice template: overriding formulae
 

Andrew

First you must unprotect the sheet.

ToolsProtectionUnprotect sheet.

Then you must select cells in the Qty column and DataData ValidationClear
AllOK

Same for the Total column.

Then in the top cell of the cyan shaded area under "Total" enter this formula

=IF(ISNUMBER(D18),D18*K18,0)

Drag/copy down to cell above Subtotal.

When happy, find INVOICE.XLT on your computer and change its name to
INVOICE.OLD in case you screw up building the new version.

FileSave asTypeTemplate(*.xlt) the altered workbook with the name of
INVOICE.XLT


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 04:39:02 -0800, Enigmaman
wrote:

I am having a problem when using the Excel 2000 Invoice template. Sometimes I
enter text into the 'Quantity' column. Then Excel is unable to calculate the
Total, in the blue shaded area.

My question is: How do I override the formula calculation in the shaded area
to simply enter the numbers and/or text of my choosing?

WTIA

Andrew Stucken