[mso] Formulas in Word
- From: David Good - ANSYS Europe <david.good@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 22 Aug 2002 12:01:24 -0400
OK, I'm trying to do something which I've avoided for a long time, I'm
looking at it now because it's not my work (although it's fast becoming it
;) )
Right; onto the problem - I have what equates to an order form done in Word
tables - you know the kind of thing: (DESC, SIZE, COLOUR, PRICE, QTY,
TOTAL). As all of it's relatively fixed I'm doing it with forms - so I can
lock the document. Hence the QTY field is a drop-down with 1,2,3,4,5 etc...
I've also put the price in the price column, and entered (Table>Formula) a
[QTY cell]*[PRICE cell] formula.
My problem is now two-fold;
1. The formulas only seem to update when I highlight the field and
press F9, or "update field"
2. If I lock the form and use the drop-down then the formula doesn't
seem to work at all
Any way around either problem? - #1's the main one - unless it updates
automatically (pref. without macros) I'll have to find another way.
I'm hoping I've missed something obvious.
Oh, and much as I'd like to embed an excel doc, or use Excel the form needs
to be in Word, and kept simple.
If anyone's kind enough to help, and needs to see the .doc just let me know,
Cheers,
Dave.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
