A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

calculations in tables



 
 
Thread Tools Display Modes
  #1  
Old July 28th, 2004, 01:28 AM
Beth
external usenet poster
 
Posts: n/a
Default calculations in tables

i have created a form in Word, therefore need to "lock-
down" the document. The issue I am having is that my form
contains a table requiring calculations. once i lock down
the form, customers using the form can not drop in numbers
to allow the calculations automatically fill in.

additionally, the calculations i would like to include in
the table seem restricted to only numeric formulas. can i
name other cells in part of the calculation?

with that said, i used an Excel table instead of a Word
table for the calculations requiring other cells, but when
i put on the lock, the table is not accessible by
customers.

can you help me identify a solution?

thanks!
Beth

  #2  
Old July 29th, 2004, 01:06 AM
macropod
external usenet poster
 
Posts: n/a
Default calculations in tables

Hi Beth,

If your customers need to insert data into the table, you'll either have to
provide formfields for them to do that with, or put the table in an
unprotected section of the document.

As for what you can do with table formulae, take a look at:
http://www.wopr.com/cgi-bin/w3t/show...&Number=365442
(url all one line)

Cheers


"Beth" wrote in message
...
i have created a form in Word, therefore need to "lock-
down" the document. The issue I am having is that my form
contains a table requiring calculations. once i lock down
the form, customers using the form can not drop in numbers
to allow the calculations automatically fill in.

additionally, the calculations i would like to include in
the table seem restricted to only numeric formulas. can i
name other cells in part of the calculation?

with that said, i used an Excel table instead of a Word
table for the calculations requiring other cells, but when
i put on the lock, the table is not accessible by
customers.

can you help me identify a solution?

thanks!
Beth



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How: delete tables & save text? Stan Tables 6 June 22nd, 2004 07:41 PM
Use a make-table query to combine two existing tables Matt Running & Setting Up Queries 1 June 16th, 2004 01:53 AM
searching for "join tables" and "join word tables" Uncle Bill Tables 1 June 11th, 2004 09:33 PM
How do I design a database based on the information that will be stored? - Copy of Tables and hirearchies.zip (0/1) Jim Database Design 1 June 1st, 2004 01:44 PM
Pivot Tables Scott V. Worksheet Functions 0 October 4th, 2003 10:37 PM


All times are GMT +1. The time now is 11:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.