Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Word
application.errors
conversions
docmanagement
drawing.graphics
formatting.longdocs
international
internet.assistant
mail
mailmerge.fields
menustoolbars
newusers
numbering
oleinterop
pagelayout
printingfonts
setup.networking
spelling.grammar
tables
vba.addins
vba.beginners
vba.customization
vba.general
vba.userforms
web.authoring
word6-7macros
word97vba
  
 
date: Mon, 16 Jun 2008 04:03:03 -0700,    group: microsoft.public.word.tables        back       


SUM refering to a second table is not working any more   
Hello,

nice forum here. 

I have a old Word .doc with some (2) macro in but it is not working any more.

The .doc contains 3 tables
1 tabel for header  (Table 1)
1 table for product pricing (Table 2 named POSITIONEN)
  name of prod., number of prod. and price per each 
  which is calculated to a price per line
1 table which grep the colume where the price per line is calculated and sum 
it up

Table1 has 4 colums
Table2 has 6 colums
Table3 has 2 colums

The formula I use in Table3 B1 is:

 =SUM(POSITIONEN f:f) \# "#.##0,00 €;(#.##0,00 €)
 

But all I get is

 !Syntaxfehler, :

#####################

Thank you for your help.


Bernhard Stillger, Germany
date: Mon, 16 Jun 2008 04:03:03 -0700   author:   Bernhard

RE: SUM refering to a second table is not working any more   
"Bernhard" wrote:

> Hello,
> 
> nice forum here. 
> 
> I have a old Word .doc with some (2) macro in but it is not working any more.
> 
> The .doc contains 3 tables
> 1 tabel for header  (Table 1)
> 1 table for product pricing (Table 2 named POSITIONEN)
>   name of prod., number of prod. and price per each 
>   which is calculated to a price per line
> 1 table which grep the colume where the price per line is calculated and sum 
> it up
> 
> Table1 has 4 colums
> Table2 has 6 colums
> Table3 has 2 colums
> 
> The formula I use in Table3 B1 is:
> 
>  =SUM(POSITIONEN f:f) \# "#.##0,00 €;(#.##0,00 €)
>  

If it used to work and it doesn't anymore, I think you will agree that it 
means something has changed.

Have you tried to change the formula?
Have you modified Table 2 in such a way that the bookmark is not where it 
should be anymore?
Have you changed Office/Windows Version?
Have you changed the system language?
date: Mon, 16 Jun 2008 05:10:01 -0700   author:   Jean-Guy Marcil

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us